Snowman Posted October 27, 2003 Share Posted October 27, 2003 ive just loaded up the newsdesk onto a ms2 snapshot and im getting this same sql error from the code. anyone have a fix for it? Quote Link to comment Share on other sites More sharing options...
Snowman Posted October 27, 2003 Share Posted October 27, 2003 Ah i have it almost all sorted now, forgot to make the page split changes... :rolleyes: I have one issue however that i just cant figure out. I cant seem to upload any images via the admin. I get no errors but no images either. I also get a red x (no image) directly under the language flag. anyone have any ideas? Quote Link to comment Share on other sites More sharing options...
Snowman Posted October 29, 2003 Share Posted October 29, 2003 Ok i have the mod working fine in MS2 now apart from one issue. I have Ian's Poll mod installed, and when i visit pollbooth.php fter making a vote or viewing a comment i get the following error from the newsdesk box. Warning: in_array(): Wrong datatype for second argument in /home/stadmin/public_html/includes/boxes/newsdesk.php on line 87 Warning: in_array(): Wrong datatype for second argument in /home/stadmin/public_html/includes/boxes/newsdesk.php on line 94 this one has me beat.... anyone seen this before? Quote Link to comment Share on other sites More sharing options...
lopes_andre Posted November 1, 2003 Share Posted November 1, 2003 Hi, Anyone have the fixed SQL sintax? I am getting errors in database import. Regards, Andre. Quote Link to comment Share on other sites More sharing options...
lopes_andre Posted November 1, 2003 Share Posted November 1, 2003 It's only INSERTS on SQL, I think there is no problem... I will finish the install. Sorry last post. Quote Link to comment Share on other sites More sharing options...
lopes_andre Posted November 1, 2003 Share Posted November 1, 2003 (edited) Ok, Installation done in OSC MS2, I have erased all INSERTS in SQL code, but is not working with MS2, I get this errors when try to creat new category in admin Fatal error: Call to undefined function: tep_array_merge() in /home/aflopes/public_html/shop/catalog/admin/newsdesk.php on line 66 Somebody know the code changes to put this working on OSC MS2? Regards Andre. Edited November 1, 2003 by lopes_andre Quote Link to comment Share on other sites More sharing options...
Snowman Posted November 1, 2003 Share Posted November 1, 2003 andre change all references to tep_array_merge to just array_merge Quote Link to comment Share on other sites More sharing options...
lopes_andre Posted November 2, 2003 Share Posted November 2, 2003 Thks Steve, I will do it. Regards, Andre. Quote Link to comment Share on other sites More sharing options...
lopes_andre Posted November 2, 2003 Share Posted November 2, 2003 (edited) Ok, I have this contribution installed in my OSC MS2 with the replace on newsdesk.php of "tep_array_merge to just array_merge". With this replace the contribution its working on MS2 but not 100% When I create a category, the category is created but gives this error: Fatal error: Call to undefined function: tep_get_uploaded_file() in /home/aflopes/public_html/shop/catalog/admin/newsdesk.php on line 92 The second error I have is this. When I try to post news on this screen(image above), my Internet Explorer crashes :( Please let me know how to solve this problem. Regards, Andre. Edited November 2, 2003 by lopes_andre Quote Link to comment Share on other sites More sharing options...
holyone Posted November 8, 2003 Share Posted November 8, 2003 Hi ! :angry: I have install the NewsDesk.... and i got to the part in the install that i need to test the admin section of the module... when i try to enter the admin section i get a SQL error.... and the modules isn't working... can some one please can tell me how to fix? I have to be able to have in my OSC some content.... Thanks, holyone. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 12, 2003 Share Posted November 12, 2003 Did anyone figure out the solution for this error: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_a select count(select p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_added, p.newsdesk_status, p.newsdesk_image, p.newsdesk_image_two, p.newsdesk_image_three, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, NULL) as final_price from newsdesk_description pd, newsdesk p left join manufacturers m on p.newsdesk_id = m.manufacturers_id, newsdesk_to_categories p2c left join specials s on p.newsdesk_id = s.products_id where p.newsdesk_status = \'1\' and p.newsdesk_id = p2c.newsdesk_id and pd.newsdesk_id = p2c.newsdesk_id and pd.language_id = \'1\' and p2c.categories_id = \'9\' order by pd.newsdesk_article_name) as total [TEP STOP] Any help would be really appreciated. This ones got me stumped Quote Link to comment Share on other sites More sharing options...
Guest Posted November 13, 2003 Share Posted November 13, 2003 I still cant figure this out!!! Quote Link to comment Share on other sites More sharing options...
Guest Posted November 13, 2003 Share Posted November 13, 2003 (edited) Please Help me im going nuts! :blink: Edited November 13, 2003 by inquisitivemind Quote Link to comment Share on other sites More sharing options...
eppies Posted November 13, 2003 Share Posted November 13, 2003 Did anyone figure out the solution for this error: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_a select count(select p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_added, p.newsdesk_status, p.newsdesk_image, p.newsdesk_image_two, p.newsdesk_image_three, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, NULL) as final_price from newsdesk_description pd, newsdesk p left join manufacturers m on p.newsdesk_id = m.manufacturers_id, newsdesk_to_categories p2c left join specials s on p.newsdesk_id = s.products_id where p.newsdesk_status = \'1\' and p.newsdesk_id = p2c.newsdesk_id and pd.newsdesk_id = p2c.newsdesk_id and pd.language_id = \'1\' and p2c.categories_id = \'9\' order by pd.newsdesk_article_name) as total [TEP STOP] Any help would be really appreciated. This ones got me stumped hello, i notice that in the select count got 2 p.newsdesk_date_added, try delete one of the p.newsdesk_date_added, it should work. :D Quote Link to comment Share on other sites More sharing options...
Admiral Keth Posted November 13, 2003 Share Posted November 13, 2003 I, too, am receiving the frustrating error 1064 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') as total' at line 1 select count() as total [TEP STOP] This only occurs if I activate Categories from the admin control panel, then select a category from the Category InfoBox. I have gone through the code with a fine-tooth comb, and cannot find where this is occurring. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 13, 2003 Share Posted November 13, 2003 Did anyone figure out the solution for this error: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_a select count(select p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_added, p.newsdesk_status, p.newsdesk_image, p.newsdesk_image_two, p.newsdesk_image_three, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, NULL) as final_price from newsdesk_description pd, newsdesk p left join manufacturers m on p.newsdesk_id = m.manufacturers_id, newsdesk_to_categories p2c left join specials s on p.newsdesk_id = s.products_id where p.newsdesk_status = \'1\' and p.newsdesk_id = p2c.newsdesk_id and pd.newsdesk_id = p2c.newsdesk_id and pd.language_id = \'1\' and p2c.categories_id = \'9\' order by pd.newsdesk_article_name) as total [TEP STOP] Any help would be really appreciated. This ones got me stumped hello, i notice that in the select count got 2 p.newsdesk_date_added, try delete one of the p.newsdesk_date_added, it should work. :D eppies, I had already noticed that but i can not find a refrence to 2 "p.newsdesk_date_added" in the file. thats why i am so confused. is it reffering to another file if so which one. BTW this is newsdesk_index.php and an example of it can be seen on the test site here: http://www.inquisitivemind.com.au/musclege...php/newsPath/19 Thanks all for your help. Quote Link to comment Share on other sites More sharing options...
Admiral Keth Posted November 13, 2003 Share Posted November 13, 2003 inquisitivemind, I think he meant that there were two occurrances of the p.newsdesk_date_added in the statement: p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_added, Quote Link to comment Share on other sites More sharing options...
eppies Posted November 14, 2003 Share Posted November 14, 2003 inquisitivemind, I think he meant that there were two occurrances of the p.newsdesk_date_added in the statement: p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_added, that's right Admiral Keth, that's what i mean. :lol: Quote Link to comment Share on other sites More sharing options...
Guest Posted November 14, 2003 Share Posted November 14, 2003 inquisitivemind, I think he meant that there were two occurrances of the p.newsdesk_date_added in the statement: p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_added, that's right Admiral Keth, that's what i mean. :lol: I realise that is what he meant but i cant find these occurances in the file. ie if i do a find "p.newsdesk_date_added, p.newsdesk_id, p.newsdesk_date_added" it say can not find. and evene whe i find "p.newsdesk_date_added" and manually look for two occurances of this in the same statement nothing turns up i can post the file here if it helps? Quote Link to comment Share on other sites More sharing options...
Admiral Keth Posted November 14, 2003 Share Posted November 14, 2003 It appears as if both Newsdesk and Faqdesk are experiencing the same issue with regards to Category functionality and the dreaded 1064 error...it doesn't work. After spending hours commenting and uncommenting code, I've come to the conclusion that, if you want to use this contribution, you must disable Categories in the Admin control panel and simply use the Articles feature. Is there anyone who has succeeded in getting Categories in either Newsdesk or Faqdesk to properly function? If so, please post a link to a copy of newsdesk_index.php so we can compare code. I'm no slouch at PHP/MySQL, but this has me perplexed. Quote Link to comment Share on other sites More sharing options...
Admiral Keth Posted November 14, 2003 Share Posted November 14, 2003 Hey again,looks like I fixed it... in includes/modules/newsdesk_listing.php, replace $listing_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_NEWSDESK_SEARCH_RESULTS, $listing_numrows_sql, $listing_numrows); with: $listing_split = new splitPageResults($listing_sql, $HTTP_GET_VARS['page'], MAX_DISPLAY_NEWSDESK_SEARCH_RESULTS, 'p.newsdesk_id'); and the error is gone... [/code] OK, this solution worked for my particular error. Thanks, beffy! Quote Link to comment Share on other sites More sharing options...
Earthkeeper Posted December 5, 2003 Share Posted December 5, 2003 I've got everything worked out fine. However I don't seem to be able to use the text formatting such as glow or text size. A post has been made earlier in this thread but no further discussion is made. Any one know how to get this to work? Thanks :) Quote Link to comment Share on other sites More sharing options...
manix Posted February 12, 2004 Share Posted February 12, 2004 hey guys :-) please forgive if the answer is in one of the previous 22 pages :-) but I have read the pages so many times now and just cant finde the answer. I stille have this error: Fatal error: Call to undefined function: get_uploaded_file() in c:\programmer\apache\apache\htdocs\dvdjay\admin\newsdesk.php on line 918 what do I do?? If the answer is postet, please tell me where. just cant finde out by my self.. thanks alot to u alle :-) John Quote Where is the anykey?? Link to comment Share on other sites More sharing options...
manix Posted February 12, 2004 Share Posted February 12, 2004 Hi it's me again :-) Sorry guys but it's a mess now! Dont know what happend but now I cant get access to my admin page: Fatal error: Call to undefined function: tep_href_link() in c:\programmer\apache\apache\htdocs\dvdjay\admin\index.php on line 21 I realy hope someone can help now, it's not funny not being able to update/add new products. please help me. Thanks alot again john Quote Where is the anykey?? Link to comment Share on other sites More sharing options...
moyashi Posted February 15, 2004 Author Share Posted February 15, 2004 lo All, NewsDesk and FaqDesk were broken by MS2. The main developer of osc felt that it wasn't important enough to inform developers of contributions that several major changes to parts of the code happened. Due to this reason, Myself and I'm sure many others got frustrated and just basically took a major haitus in regards to development. Why debug code that could have been recorded or introduced a developers section on the site to prevent such problems. I have basically finished the conversions of FaqDesk and NewsDesk to work with MS2. The fixes were extrememly easy but the troubleshooting part was horribly tedious and time consuming. I will be releasing these as soon as I finish testing and payed work that I need to finish first. I'm hoping to have these out within the next 2 weeks. cheers. Moyashi -- Carsten Quote NewsDesk(934) / FAQDesk(1106) / OrderCheck(1168) ::: Link to comment Share on other sites More sharing options...
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.