Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

Problem With Dynamic Menu

This topic is locked: you cannot edit posts or make replies.

 

sonoangelo
Quote
Posts: 200 Location: Sicilia
Thu 12 Apr, 2007 12:10
Subject: Problem With Dynamic Menu
hello :oops:

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 :wink: :mrblue:

Profile PM   Website MSN Skype
seldon1965
Quote
Posts: 17
Thu 12 Apr, 2007 13:47
Subject: 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

Profile PM  
sonoangelo
Quote
Posts: 200 Location: Sicilia
Thu 12 Apr, 2007 15:30
Subject: Re: Problem With Dynamic Menu
thanks a lot, works perfect ;) :mrblue:

Profile PM   Website MSN Skype
This topic is locked: you cannot edit posts or make replies.
 

Page 1 of 1


  
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

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.8209s (PHP: 2% SQL: 98%)
SQL queries: 13 - Debug Off - GZIP Enabled