Member / Navigation Menu SQL Error

Just updated D7.0.1 from Dolphin 7.0.1 - current stable  and updated again on this link http://www.boonex.com/trac/dolphin/browser/trunk/administration updated by Anton Lesnikov.

Under Administration/BUILDER "Member Menu / Navigation Menu"  error  Database SQL error

any ideas how to fix?

Quote · 23 May 2010

Show as the full mysql error

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 23 May 2010

Sorry SasheE its Database query error Smile

in errorlog files warning:

[23-May-2010 21:04:17] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/ixed.5.2ts.lin' - /usr/local/lib/php/extensions/no-debug-zts-20060613/ixed.5.2ts.lin: undefined symbol: executor_globals_id in Unknown on line 0

Quote · 24 May 2010

Sorry SasheE its Database query error Smile

in errorlog files warning:

[23-May-2010 21:04:17] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/ixed.5.2ts.lin' - /usr/local/lib/php/extensions/no-debug-zts-20060613/ixed.5.2ts.lin: undefined symbol: executor_globals_id in Unknown on line 0

No it's not I need. Please open the - inc/classes/BxDolDb.php find this string : define( 'DB_FULL_DEBUG_MODE', false); and replace on : define( 'DB_FULL_DEBUG_MODE', true);


try navigate your page (that show you error). There should generate more details error report

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 24 May 2010
Query:
SELECT `ID`, `Name`, `Movable` FROM `sys_menu_member` WHERE `Active`='1' AND `Position`='top' AND `Type`<>'linked_item' ORDER BY `Order`
Mysql error:
Unknown column 'Movable' in 'field list'

Quote · 24 May 2010

No need to put Full log :)

Query:
SELECT `ID`, `Name`, `Movable` FROM `sys_menu_member` WHERE `Active`='1' AND `Position`='top' AND `Type`<>'linked_item' ORDER BY `Order`
Mysql error:
Unknown column 'Movable' in 'field list'

is enough to anybody.

So, this error mean that you haven`t such field (Movable) in your table `sys_menu_member`
check which type is that field, add this field to your version. And all will work. Good luck !
Quote · 25 May 2010

already added these fields in sys_menu_members & sys_menu_top

Field          Type              Collation
-----------------------------------------------
Movable    varchar(250)  utf8_general_ci
Clonable   varchar(250)  utf8_general_ci

it's working now but it ask few questions the default value of varchar?

thanks AndreyP

Quote · 26 May 2010
 
 
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.