adi_menu – section hierarchy, section menu and breadcrumb trail

debegray · 2009-02-06 20:50:48

I am getting an extensive error message when I try to install this from the adi_menu tab. This is the beginning:

Warning: Unknown column ‘adi_menu_exclude’ in ‘field list’ SELECT name, title, adi_menu_parent, adi_menu_title, adi_menu_exclude, adi_menu_clone, adi_menu_sort FROM txp_section ORDER BY name in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 82

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 288

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 290

Notice: Undefined variable: out in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 352

Warning: Invalid argument supplied for foreach() in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 148

Warning: Invalid argument supplied for foreach() in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 264

gomedia · 2009-02-06 22:22:34

debegray wrote:

I am getting an extensive error message when I try to install this from the adi_menu tab. This is the beginning:

Yikes! What version of adi_menu are you installing on what version of Textpattern?

Versions before 0.5 displayed errors in the Admin tab until properly installed.

debegray · 2009-02-06 22:45:24

I am using Textpattern 4.0.8 and adi_menu 0.7.

gomedia · 2009-02-06 23:19:42

That combination works for me. And I’ve just re-installed it to make sure.

At what point do you see the errors? Is it after installing/activating adi_menu in the Plugins tab but before clicking “Install” in the adi_menu tab?

If you ignore the errors and click “Install” in adi_menu tab do they disappear?

debegray · 2009-02-06 23:45:09

I see the error message after I check Install and click “Do Admin” in the adi_menu tab.

gomedia · 2009-02-07 00:08:11

debegray wrote:

I see the error message after I check Install and click “Do Admin” in the adi_menu tab.

Hmm, very odd. The errors indicate that one or more of adi_menu’s columns (in the database) don’t exist. The thing is, that’s what the Install operation is for – to add them in the first place.

After you’ve clicked for Install there should be a message from adi_menu in the top left of the page. Normally it would say something like “adi_menu installed”. What do you get?

Whereabouts physically on the page do you see the errors? Do you get anything else displayed? In principal, there should be a sections table above the “Do admin” button and a Section summary below.

Can you have a look under the Diagnostic tab & tell me if there’s any warnings there. Also what’s your version of MySQL (you’ll see it in the info window)?

Is this a first-time install or an upgrade from a previous version of adi_menu?

What happens if you try to uninstall adi_menu before installing it?

debegray · 2009-02-07 15:46:43

I think that’s the case – the columns are not being installed. Diagnostics are fine. MySQL version is MySQL: 4.0.27-max-log.

This is the message on the upper left: adi_menu: install not successful

Here’s the whole page after the install attempt:

Warning: 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 ‘BOOLEAN DEFAULT FALSE NOT NULL’ at line 1 ALTER TABLE txp_section ADD adi_menu_exclude BOOLEAN DEFAULT FALSE NOT NULL; in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 82
Textpattern

adi_menu: install not successful Content Presentation Admin Extensions View Site Sections Pages Forms Style adi_menu

Warning: Unknown column ‘adi_menu_exclude’ in ‘field list’ SELECT name, title, adi_menu_parent, adi_menu_title, adi_menu_exclude, adi_menu_clone, adi_menu_sort FROM txp_section ORDER BY name in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 82

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 288

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 290

Notice: Undefined variable: out in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 352

Warning: Invalid argument supplied for foreach() in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 148

Warning: Invalid argument supplied for foreach() in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 264
Section Title Exclude? Parent Sort order Clone? Clone title

Administration

Install Uninstall Import

Warning: Unknown column ‘adi_menu_clone’ in ‘field list’ select name,title,adi_menu_parent,adi_menu_clone,adi_menu_title from txp_section where adi_menu_exclude = 0 order by NULL in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 82

Warning: Invalid argument supplied for foreach() in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 477
Summary

The above configuration will generate the following section hierarchy (subject to adi_menu tag attributes):

This is a first time install, not an upgrade. It’s a new installation of Textpattern and the only other plugin that is active is hak_tinymce.

When I try to uninstall, I get more code and a message that it was not successful. The code is, in part, Warning: Can’t DROP ‘adi_menu_exclude’.

gomedia · 2009-02-07 21:05:38

Thanks debegray. I think the clue is in the first bit:

Warning: 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 ‘BOOLEAN DEFAULT FALSE NOT NULL’ at line 1 ALTER TABLE txp_section ADD adi_menu_exclude BOOLEAN DEFAULT FALSE NOT NULL; in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 82
Textpattern

It looks like you’re on a old-ish version of MySQL that can’t handle my (possibly dodgy) query command syntax. This has happened before and some tightening up of the code fixed it. BOOLEAN is probably the issue. Leave it with me.

gomedia · 2009-02-07 21:51:48

debegray,

Try this one: 0.7.1

debegray · 2009-02-08 14:42:03

Thanks – I’ll give it a shot!

debegray · 2009-02-08 14:45:50

Now, this is what I get as soon as I click on the adi_menu tab, before I even try to install:

Warning: Unknown column ‘adi_menu_exclude’ in ‘field list’ SELECT name, title, adi_menu_parent, adi_menu_title, adi_menu_exclude, adi_menu_clone, adi_menu_sort FROM txp_section ORDER BY name in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 82

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 288

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 290

Notice: Undefined variable: out in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 358

Warning: Invalid argument supplied for foreach() in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 153

Warning: Invalid argument supplied for foreach() in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 269
Section Title Exclude? Parent Sort order Clone? Clone title

Administration

Install Uninstall Import

Warning: Unknown column ‘adi_menu_clone’ in ‘field list’ select name,title,adi_menu_parent,adi_menu_clone,adi_menu_title from txp_section where adi_menu_exclude = 0 order by NULL in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_db.php on line 82

Warning: Invalid argument supplied for foreach() in /homepages/23/d179350331/htdocs/textpattern/textpattern/lib/txplib_misc.php(570) : eval()’d code on line 541

gomedia · 2009-02-10 13:21:55

I’ve been working with debegray off-forum and have produced an interim version 0.7.2 in which I’ve made changes to accommodate MySQL version 4.

I’ll do some tests, and assuming they’re forward compatible with MySQL 5 they’ll appear in the next full version of adi_menu.

nubian · 2009-02-12 09:14:48

Hi, just started using textpattern and this plugin, is it possible to use the “separator” attirbute on the menu just like in the breadcrumbs?

Thanks!

gomedia · 2009-02-12 09:32:53

nubian wrote:

Hi, just started using textpattern and this plugin, is it possible to use the “separator” attirbute on the menu just like in the breadcrumbs?

Menus are generated as nested unordered lists (i.e. <ul> & <li> elements) so I’m not sure where a separator would be used. I guess you could imagine the menus as being in 3D. The breadcrumbs, however, are a straight line list (i.e. in 2D) so separators are used to separate the individual crumbs.

nubian · 2009-02-12 11:08:15

Thanks for your reply.
Well, here’s currently what I have as a navigation link

home // blog // contact

now, I could probably use an image for the “//” and CSS-attach it to the <li> or <a> etc.
but I thought I could just add it in, but not make it part of the link.

Textpattern CMS

Textpattern CMS support forum

#76 2009-02-06 20:50:48

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#77 2009-02-06 22:22:34

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#78 2009-02-06 22:45:24

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#79 2009-02-06 23:19:42

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#80 2009-02-06 23:45:09

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#81 2009-02-07 00:08:11

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#82 2009-02-07 15:46:43

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#83 2009-02-07 21:05:38

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#84 2009-02-07 21:51:48

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#85 2009-02-08 14:42:03

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#86 2009-02-08 14:45:50

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#87 2009-02-10 13:21:55

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#88 2009-02-12 09:14:48

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#89 2009-02-12 09:32:53

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

#90 2009-02-12 11:08:15

Re: adi_menu – section hierarchy, section menu and breadcrumb trail

Board footer