Problem With Dynamic Menu

The time now is Wed 25 Feb, 2026 15:31 • All times are UTC + 1 Hour

Problem With Dynamic Menu

Page 1 of 1

sonoangelo

Joined: December 2006
Posts: 200
Location:

Sicilia

Problem With Dynamic Menu

hello

when i go to edit my dynamic menu in the page cms_menu.php i get this error

Code: [Download] [Hide] [Select]

Could not query menu table

DEBUG MODE

SQL Error : 1146 Table 'Sql114717_1.phpbb_TMPcms_nav_menu' doesn't exist

SELECT * FROM phpbb_TMPcms_nav_menu WHERE menu_parent_id = '0' ORDER BY menu_name ASC

Line : 1047

File : cms_menu.php

and if i active the block, for example when i go in the forum, it doesn't show but appers that error.

can you write me the sql query to run for create the table? Thaaaaaanks

#1 Thu 12 Apr, 2007 12:10

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

seldon1965

Joined: January 2007
Posts: 17

Re: Problem With Dynamic Menu

Code: [Download] [Hide] [Select]

CREATE TABLE `XXXXXXX_cms_nav_menu` (

  `menu_item_id` mediumint(8) unsigned NOT NULL auto_increment,

  `menu_id` mediumint(8) unsigned NOT NULL default '0',

  `menu_parent_id` mediumint(8) unsigned NOT NULL default '0',

  `cat_id` mediumint(8) unsigned NOT NULL default '0',

  `cat_parent_id` mediumint(8) unsigned NOT NULL default '0',

  `menu_status` tinyint(1) NOT NULL default '0',

  `menu_order` smallint(5) NOT NULL default '0',

  `menu_icon` varchar(255) default NULL,

  `menu_name_lang` varchar(150) default NULL,

  `menu_name` varchar(150) default NULL,

  `menu_desc` text,

  `menu_link` varchar(255) default NULL,

  `menu_link_external` tinyint(1) NOT NULL default '0',

  `auth_view` tinyint(2) NOT NULL default '0',

  `auth_view_group` tinytext NOT NULL,

  PRIMARY KEY  (`menu_item_id`),

  KEY `cat_id` (`cat_id`)

) ;

replace xxxxxx with your table prefix

#2 Thu 12 Apr, 2007 13:47

sonoangelo Joined: December 2006 Posts: 200 Location: Sicilia	Re: Problem With Dynamic Menu thanks a lot, works perfect
#3 Thu 12 Apr, 2007 15:30

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Wed 25 Feb, 2026 15:31 • All times are UTC + 1 Hour

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

Icy Phoenix

Problem With Dynamic Menu

Was this topic useful?

Was this topic useful?