Category Menu - SQL Error

3 posts by 2 authors in: Forums > CMS Builder
Last Post: December 22, 2008   (RSS)

By rsekaly - December 21, 2008

I created a section editor called "Demo" (see attached 'demo.ini.php' file). When I try to add a record, I get the following SQL error:

"MySQL Error: Unknown column 'name' in 'field list'."

I have no reference to a field named "name" anywhere in the schema file. I tried to manually change the table by adding a field named 'name" and it worked. However, when I removed it, I could no longer edit the existing record as it gave me the same error.

Any ideas? Looks like a bug to me!
--
Ragi Sekaly

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
Attachments:

demo-ini_001.php 2K

Re: [rsekaly] Category Menu - SQL Error

By Dave - December 22, 2008

Hi Ragi,

I was able to reproduce that locally with your attached schema file.

I just checked in the code, because we need to generate pulldowns of the parent categories, etc we need to know which field has the category name in it, so "name" is a hard coded and required field. It should be automatically created when you create a new category section. How did you create the demo section?

The quick fix is to go with the "name" field instead of "title".

Let me know if that works for you.
Dave Edis - Senior Developer
interactivetools.com