Database query error - Navigation Menu Builder

Recently I moved my site (created with 7.0.1) to a different domain hosted on the same server. I installed a fresh copy of 7.0.2 and copied the databases to the new site. Everything works great except for the "Navigation Menu" Builder and the "Member Menu" Builder. When attempting to access those it displays the red box with "Error: Database query error". Then I received an email with the following:



administration/nav_menu_compose.php at line 130.
Called 'db_res' function with erroneous argument #0.



Any thoughts?

Quote · 4 Jul 2010

Was the database from Dolphin 7.0.1, or was the previous web site updated to Dolphin 7.0.2 before the transfer?

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 4 Jul 2010

The database is from 7.0.1

Quote · 4 Jul 2010

Hello we need full error description for help you!

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

Database error in

Query:

SELECT `ID`, `Name`, `Movable` FROM `sys_menu_top` WHERE `Active`=1 AND `Type`='top' ORDER BY `Order`

Mysql error: Unknown column 'Movable' in 'field list'

Found error in the file 'administration/nav_menu_compose.php' at line 130.
Called 'db_res' function with erroneous argument #0.

Quote · 4 Jul 2010

I believe the issue is because you are using a Dolphin 7.0.1 database with Dolphin 7.0.2. There were a number of database-related changes between the two releases. Try installing Dolphin 7.0.1, adding the database and updating to Dolphin 7.0.2.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 4 Jul 2010

I believe the issue is because you are using a Dolphin 7.0.1 database with Dolphin 7.0.2. There were a number of database-related changes between the two releases. Try installing Dolphin 7.0.1, adding the database and updating to Dolphin 7.0.2.

Yes you right! there need to update sys_menu_top structure

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

That did the trick!  T H A N K S !

Quote · 4 Jul 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.