Snowman Posted June 16, 2003 Share Posted June 16, 2003 Im getting the following error on a current snapshot in faqdesk_index.php and newsdesk_index.php 1064 - You have an error in your SQL syntax near ') as total ' at line 1 select count() as total [TEP STOP] as the code is identical there must be some incompatability between the modules and CVS2.2 of MS2 ive applied the fixes already mentioned but this is one i cant seemt o solve.... can anyone please help? Quote Link to comment Share on other sites More sharing options...
gpraceman Posted June 16, 2003 Share Posted June 16, 2003 Im getting the following error on a current snapshot in faqdesk_index.php and newsdesk_index.php 1064 - You have an error in your SQL syntax near ') as total ' at line 1 select count() as total [TEP STOP] as the code is identical there must be some incompatability between the modules and CVS2.2 of MS2 ive applied the fixes already mentioned but this is one i cant seemt o solve.... can anyone please help? Below these lines in faqdesk_index.php // IF this area is included problems occur when trying to view unpopulated catagories // OR!!! is this not a but??? // Well which the @!#p$@ is it? Regular products shows the catagory while the below won't @!#@&@ There are a couple of select count(*) queries. Make sure you have an asterik between the (). Though, by the comments above there may be a known bug in there to be wary of. Quote Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories. Link to comment Share on other sites More sharing options...
Snowman Posted June 17, 2003 Share Posted June 17, 2003 its not just the newsdesk and faqdesk modules that are affected... any code with count(*) or count() seems to be throwing the error in the latest snapshots... Quote Link to comment Share on other sites More sharing options...
Guest Posted June 20, 2003 Share Posted June 20, 2003 I am using a snapshot from earlier this week. I get the following error when trying to view an FAQ category. -------------------------------------------------------------------------- 1064 - You have an error in your SQL syntax near 'select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk' at line 1 select count(select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk_date_added, pd.faqdesk_question, pd.faqdesk_answer_long, pd.faqdesk_answer_short from faqdesk_description pd, faqdesk p, faqdesk_to_categories p2c where p.faqdesk_status = '1' and p.faqdesk_id = p2c.faqdesk_id and pd.faqdesk_id = p2c.faqdesk_id and pd.language_id = '1' and p2c.categories_id = '1' order by pd.faqdesk_question) as total -------------------------------------------------------------------------- I have gone over the code from the original category/products and it succesfully uses the count(*) syntax in the SQL querry. This is very strange. Any help would be appreciated. thanks frank Quote Link to comment Share on other sites More sharing options...
dynstep Posted June 20, 2003 Share Posted June 20, 2003 Hi gpraceman (which is your favourite Grand Prix Team?:-)) Thanx a lot for your fix. Its already a few weeks ago that i work with OsCommerce. But now it goes on... ------------------------------------------------------------------------------- "If humans spoke only about things they understand, then it would be very quiet in the world" Quote Link to comment Share on other sites More sharing options...
XRaid Posted June 20, 2003 Share Posted June 20, 2003 Hi All works great with this fine contribution but i can?t solve a problem with the images 1/2/3. I?m using 2.2MS1. The upload works correct - i can find the images in the right folder and in the database there is also the correct image included. I can see the image in the admin area, but NOT in the catalog area (frontpage settings, all images enabled). I viewed all postings, but i can?t find the right answer, solving this problem. Has anyone an idea? greetings Rainer Quote Link to comment Share on other sites More sharing options...
gpraceman Posted June 20, 2003 Share Posted June 20, 2003 Hi All works great with this fine contribution but i can?t solve a problem with the images 1/2/3. I?m using 2.2MS1. The upload works correct - i can find the images in the right folder and in the database there is also the correct image included. I can see the image in the admin area, but NOT in the catalog area (frontpage settings, all images enabled). I viewed all postings, but i can?t find the right answer, solving this problem. Has anyone an idea? greetings Rainer This is what I did to get it working. Find this code in faqdesk_index.php (it will appear twice) if (($categories['categories_image'] = 'NULL') or ($categories['categories_image'] = '')) { echo tep_draw_separator('pixel_trans.gif', '1', '1'); } else { echo tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); } And replace it with this // BOF: Modified to fix image display problem //if (($category['categories_image'] = 'NULL') or ($category['categories_image'] = '')) { if (!tep_not_null($category['categories_image'])) { // EOF: Modified to fix image display problem echo tep_draw_separator('pixel_trans.gif', '1', '1'); } else { echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); } I did some other monkeying with that page, but I think this is all you need for the image display issue. Quote Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories. Link to comment Share on other sites More sharing options...
XRaid Posted June 20, 2003 Share Posted June 20, 2003 Thanks a lot for your effort. I tried it out, but it doesn?t work. The prob is not the categories-image, it is a prob with the faqdesk_image, they are not visible in the catalog area. Has anyone else an idea? greetings Rainer Quote Link to comment Share on other sites More sharing options...
XRaid Posted June 20, 2003 Share Posted June 20, 2003 Hello, i solved the problem. It think it was not a real problem. :oops: I didn?t know that the faqdesk_image only is shown in the sticky-mode. But it would be nice, if the image is also shown in the detailed FAQ. greetings Rainer Quote Link to comment Share on other sites More sharing options...
Guest Posted June 20, 2003 Share Posted June 20, 2003 See my earlier question: in file catalog/includes/modules/faqdesk/faqdesk_listing.php on or about line 17 fine the line $listing_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, $listing_sql, $listing_numrows); and change it to: $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, '*', $HTTP_GET_VARS['page']); after making this change, I got everything to work just great. I have only tried this on a most recent snapshot. frankj :D Quote Link to comment Share on other sites More sharing options...
Snowman Posted June 23, 2003 Share Posted June 23, 2003 Thanks for the fix...works perfectly to fix the error in both the newsdesk and the faqdesk :) Quote Link to comment Share on other sites More sharing options...
gpraceman Posted June 23, 2003 Share Posted June 23, 2003 See my earlier question: in file catalog/includes/modules/faqdesk/faqdesk_listing.php on or about line 17 fine the line $listing_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, $listing_sql, $listing_numrows); and change it to: $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, '*', $HTTP_GET_VARS['page']); after making this change, I got everything to work just great. I have only tried this on a most recent snapshot. frankj :D Mine works fine with the orignial code. When I look at the splitPageResults function function splitPageResults(&$current_page_number, $max_rows_per_page, &$sql_query, &$query_num_rows) { it looks like your solution would put the parameters in the wrong order. Is your splitPageResults function defined differently? Which snapshot are you using? I'm using 5/18/03. Quote Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories. Link to comment Share on other sites More sharing options...
Guest Posted June 23, 2003 Share Posted June 23, 2003 I am using a snapshot from a month later 6/15/03. Don't know why this is so different, but it seems to work fine for me with the change I noted. frankj Quote Link to comment Share on other sites More sharing options...
Guest Posted June 26, 2003 Share Posted June 26, 2003 In comparing the code from the 6/15/03 snapshot for categories.php and the modded code for faqdesk.php I was able to get all 3 images for the questions to show up by adjusting the faqdesk.php code to look more like the categories code. Specifically the new upload code. ---------------------------------- if ($faqdesk_image = new upload('faqdesk_image', DIR_FS_CATALOG_IMAGES)) { $faqdesk_image_name = $faqdesk_image->filename; } else { $faqdesk_image_name = $HTTP_POST_VARS['products_previous_image']; } if ($faqdesk_image_two = new upload('faqdesk_image_two', DIR_FS_CATALOG_IMAGES)) { $faqdesk_image_name_two = $faqdesk_image_two->filename; } else { $faqdesk_image_name_two = $HTTP_POST_VARS['products_previous_image_two']; } if ($faqdesk_image_three = new upload('faqdesk_image_three', DIR_FS_CATALOG_IMAGES)) { $faqdesk_image_name_three = $faqdesk_image_three->filename; } else { $faqdesk_image_name_three = $HTTP_POST_VARS['products_previous_image_three']; } ----------------------------------- ie; change image_three_name to image_name_three etc. I hope this helps those of you trying to debug this great contribution. frankj :D Quote Link to comment Share on other sites More sharing options...
tobz Posted July 4, 2003 Share Posted July 4, 2003 I just installed this and it looks to be a great contribution, except that everytime I click the preview button for a new FAQ, IE6 crashes. I notice a few others have had this problem too but did anyone fix it? I'm using MS1 so it's not a problem with the newer upload class. I'm guessing it is something to do with the HTML editor... Quote tobz osCommerce Links osCommerce Templates osCommerce UK <-- This site is for sale! Link to comment Share on other sites More sharing options...
vidmaster Posted August 4, 2003 Share Posted August 4, 2003 Did anyone find a fix for that MySQL error someone stated a few pages back? I'm getting the same thing using MS2. You can see the problem here: http://www.ellensgarden.com/faqdesk_index....x.php?faqPath=1 The query looks fine, no idea what's wrong. Quote Link to comment Share on other sites More sharing options...
goodolandy Posted August 10, 2003 Share Posted August 10, 2003 Just went through this entire thread but no ones has seem to have had the problem I'm now having. Do to stupid me deleting a certain table, I had to re-install my cart from scratch. I now have everything back the way it was except this time around the FAQ Desk is not working. When I'm in admin and choose to add a new question, I received the following error under the heading "Short Answer": Warning: main(includes/modules/faqdesk/html_editor_images/summary_bb.php): failed to open stream: No such file or directory in /admin/faqdesk.php on line 548 I checked the FAQ Desk files and notice that in the package there was no html_editor_images directory or summary_bb.php file so why would that directory and file be listed in faqdesk.php? Quote Link to comment Share on other sites More sharing options...
Arpit Posted September 4, 2003 Share Posted September 4, 2003 Hey guys, I am using the FAQDesk contrib, the admin side works like a charm, but on the catalog side, i am getting the following error : Warning: Failed opening 'includes/boxes/faqdesk.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site1/fst/var/www/html/catalog/includes/column_right.php on line 42 Warning: Failed opening 'includes/boxes/faqdesk_latest.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site1/fst/var/www/html/catalog/includes/column_right.php on line 43 Can anyone help? Quote The late twentieth century has witnessed a remarkable growth in scientific interest in the subject of extinction ---------------------------------------------------- Arpit Link to comment Share on other sites More sharing options...
moyashi Posted September 4, 2003 Author Share Posted September 4, 2003 You're missing those 2 boxes. Quote NewsDesk(934) / FAQDesk(1106) / OrderCheck(1168) ::: Link to comment Share on other sites More sharing options...
Ahostmaster Posted September 5, 2003 Share Posted September 5, 2003 Moyashi We need help for install FAQDesk MS2, can you make update module ? Thank you Quote Link to comment Share on other sites More sharing options...
moyashi Posted September 6, 2003 Author Share Posted September 6, 2003 Check out my Newsdesk thread. I've explained pretty much what i'm doing there. Quote NewsDesk(934) / FAQDesk(1106) / OrderCheck(1168) ::: Link to comment Share on other sites More sharing options...
GIZMO-XL Posted September 7, 2003 Share Posted September 7, 2003 I have tried to get this FAQ mod to work for a day now and I have had no luck I can't add catagories in the admin section. I see no boxes in the catalog area. and IE6 locks up. I have made all the changes in the this post and nothing works. I am running V2.2 MS2 I really need this mod for my site but I can't understand why it is such a problem to get it working... I also want the News mod but I don't want to have the same level of problems as I have had with this one. Can anyone tell me the trick to get this working with V2.2 MS2 in a clear and to the point message? Quote Link to comment Share on other sites More sharing options...
moyashi Posted September 7, 2003 Author Share Posted September 7, 2003 I'm sorry but the reason this mod doesn't work is because somebody who does the coding for osC decide to make changes and not care to tell developers like me. makes you feel real good to give back to community :oops: Quote NewsDesk(934) / FAQDesk(1106) / OrderCheck(1168) ::: Link to comment Share on other sites More sharing options...
GIZMO-XL Posted September 7, 2003 Share Posted September 7, 2003 I understand what you are saying I am also a application programmer and I feel your pain. I love the fact you took the time to develop this mod I just wish I could get it to work. From what I can see things have to be developed only for the MS1 and MS2 releases because any other version that is a milestone release the user will not be given a upgrade path to in the furtue. So I would think that if your version works out of the box for MS1 then they should not post it as a MS2 release until you decide to upgrade your code and post a MS2 release. Anyways I have read that you are working on a new version for MS2 can you tell me when it will be ready and also your newsdesk release? I really want these features on my site because it makes the product complete in my opinion. These two features should be in the base product so it become a complete solution for the people that install OSC. GIZMO Quote Link to comment Share on other sites More sharing options...
clarocque Posted September 13, 2003 Share Posted September 13, 2003 I, like may others am gettinthe following error 1064 - You have an error in your SQL syntax near 'select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk' at line 1 select count(select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk_date_added, pd.faqdesk_question, pd.faqdesk_answer_long, pd.faqdesk_answer_short from faqdesk_description pd, faqdesk p, faqdesk_to_categories p2c where p.faqdesk_status = '1' and p.faqdesk_id = p2c.faqdesk_id and pd.faqdesk_id = p2c.faqdesk_id and pd.language_id = '1' and p2c.categories_id = '2' order by pd.faqdesk_question) as total [TEP STOP] I saw the problem listed but no fix (atleast not what I saw) Any help for this???? Chris Quote osC Contributions I have published. Note: Some I only provided minor changes, updates or additions! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.