2 replies to this topic

[jack]

Hello. I've read a previous topic with same name but the solutions suggested didn't seem to help with my situation. I think I've been pretty thorough w the install documentation. Please provide me with any suggestions.

I have two links w this error:

« Error » Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: SELECT id, pagetitle, description, content, createdon, createdby FROM aerodyn_website.aero_site_content WHERE aerodyn_website.aero_site_content.parent=33 AND aerodyn_website.aero_site_content.showinmenu=1 ORDER BY menuindex DESC LIMIT menuindex;

Also, I receive these returns when executing the patch script:

OK - aero_site_content.id index doesn't exist. No action required.
Failure: Query failed: Table 'aerodyn_website.aero_log_user_agents' doesn't exist
Failure: Query failed: Table 'aerodyn_website.aero_log_visitors' doesn't exist

Any help would be very much appreciated.

[skylerb]

Hello. I've read a previous topic with same name but the solutions suggested didn't seem to help with my situation. I think I've been pretty thorough w the install documentation. Please provide me with any suggestions.

I have two links w this error:

« Error » Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: SELECT id, pagetitle, description, content, createdon, createdby FROM aerodyn_website.aero_site_content WHERE aerodyn_website.aero_site_content.parent=33 AND aerodyn_website.aero_site_content.showinmenu=1 ORDER BY menuindex DESC LIMIT menuindex;

Also, I receive these returns when executing the patch script:

OK - aero_site_content.id index doesn't exist. No action required.
Failure: Query failed: Table 'aerodyn_website.aero_log_user_agents' doesn't exist
Failure: Query failed: Table 'aerodyn_website.aero_log_visitors' doesn't exist

Any help would be very much appreciated.

Is this a new install or an upgrade? I ran into a similar issue when I upgraded from a old version of Etomite because my {prefix}site_content table didn't have the showinmenu field. Do you get this error when you try and access any page, or just two specific pages?

What error do you receive when you run the query displayed in your error message in your MySQL client? That error message can give you a clue as to why the query is failing (and how to fix it).

Also, I would check to see that you have all the appropriate Etomite tables. Consult the install/sql/etomite.sql file to see what tables should be present, and what fields each table should have. If you are missing tables, you can grab the appropriate "CREATE TABLE ..." statements from the install/sql/etomite.sql file and execute them in your MySQL client. If this is a new install, I wouldn't recommend doing this as you would probably be better off doing a reinstall if you DB is that mangled.

Skyler

[Ralph]

There is a script that comes with each update that handles any data structure changes... The one that is in the 0.6.1.4 release will check for and make all changes that have been made since Etomite 0.6 Heliades to the best of my knowledge... The installer explains all changes and it is recommended that it be run, along with reading the README file that comes with the update package... You can even run the database patch script from within the installer...