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!
"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
Ragi Sekaly
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
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.
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
interactivetools.com
Re: [Dave] Category Menu - SQL Error
By rsekaly - December 22, 2008
Dave: All I did was create a category menu and renamed "name" to "title" and removed "content".
Now that I understand why, its not an issue, as the only person who sees the db and the code is me!
Thanx for explaining this Dave!
Now that I understand why, its not an issue, as the only person who sees the db and the code is me!
Thanx for explaining this Dave!
--
Ragi Sekaly
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
Ragi Sekaly
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke