 | | |
|
roddruce
User
Apr 23, 2008, 7:26 PM
Post #1 of 5
(188 views)
Shortcut
|
|
Unknown column 'title' in 'order clause'
|
Can't Post
|
|
Hello there,
I have just purchased V1.14 and read all the help files thoroughly though they aren't simplified enough for newbies to CMS. I have created a new user but getting the php code to work is proving difficult.
Below is the page in question with a MySQL a order clause error? This is ambiguous to me. I know santa clause but nor order clause!
In this sub-domain folder I renamed the index.htm to index.php and dropped the Page Viewer code into this file and uploaded to the sub-domain directory.
What I don’t understand is why do I save this viewer code as "demoPage.php"? I have just ignored that for now.
You can see the problem in the url below…
http://demo.ourmenus.com.au
Page Viewer (demo): MySQL Error: Unknown column 'title' in 'order clause'
This is the demo page user account if you want to see what I have done.
http://www.ourmenus.com.au/cmsAdmin/admin.php
Username: demo
Password: demo
Cheers - Rod
|
|
| |
|
Dave
Staff
/ Moderator
Apr 23, 2008, 9:16 PM
Post #2 of 5
(184 views)
Shortcut
|
|
Re: [roddruce] Unknown column 'title' in 'order clause'
[In reply to]
|
Can't Post
|
|
Rod, welcome to the forums! We're here to help!
For the Order By error, try blanking out the "Order By" value in the Section Editor Admin and PHP viewer code. The orderBy lists it the fields to sort by, but it sounds like the 'title' field isn't there anymore.
As for the filename, you don't have to name it demoPage.php. You can name it whatever you like.
Try blanking out the Order By values and let me know if that fixes it!
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
roddruce
User
Apr 23, 2008, 10:23 PM
Post #3 of 5
(181 views)
Shortcut
|
|
Re: [Dave] Unknown column 'title' in 'order clause'
[In reply to]
|
Can't Post
|
|
Thanks Dave, that worked a treat.
Will I need to blank out the order by values each time I create a new section from now on?
For your information, I can't open any php file generated by the viewer in my webeditor "Namo". So I have had to use notepad, which is probably the correct method to make web pages anyway, but I wonder why my Webeditor is now always closing down?
Rod
|
|
| |
|
Dave
Staff
/ Moderator
Apr 24, 2008, 9:32 AM
Post #4 of 5
(175 views)
Shortcut
|
|
Re: [roddruce] Unknown column 'title' in 'order clause'
[In reply to]
|
Can't Post
|
|
The order by values is just a list of fields to sort by. So if you're creating a single page section you can blank it out. For multipage section you'll want to set it the fields you want to sort by.
As far as the editor, I'm not sure why the editor is closing down. Does it allow you to open any PHP files at all?
In any case, glad you got your demo page working, let us know if you have any other problems!
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
roddruce
User
Apr 24, 2008, 3:30 PM
Post #5 of 5
(171 views)
Shortcut
|
|
Re: [Dave] Unknown column 'title' in 'order clause'
[In reply to]
|
Can't Post
|
|
In regard to the webeditor, it will open all php files except CMSB but I am sure it is a flaw in the webeditor as an earlier version will open these files as will other web editors I tried out last night.
Rod
|
|
| |
|
