Modules - Ver7B2

Out of all the modules, I have 6 where installation fails for a similar reason. BD ver 5.0.83 MySQL

 

Events - Groups - Poll - Shoutbox - Simple Messenger - Store

 

In each case the error message is : There are errors in the following MySQL queries:
-- -- Error: 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 '' at line x

 

Quote · 26 Jul 2009

Find the code in the install.sql file for each of these 6 modules.

It will look something like this (depending on which module you are fixing:

`Eval` = 'return BxDolService::call(''groups'', ''get_member_menu_item'', array({ID}));',

`Type` = 'linked_item',

`Parent` = '1';

Simply delete the carriage-return/line-feeds and append the offending lines to the previous one.  It will then look something like this:

`Eval` = 'return BxDolService::call(''groups'', ''get_member_menu_item'', array({ID}));',`Type` = 'linked_item',`Parent` = '1';  (all on one line)

Save the changes and upload the modified file to your server.

That's all it took to solve this problem on my server.

Hopes this helps.

...Jason

Quote · 27 Jul 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.