MySQL Error HELP

6 posts by 3 authors in: Forums > CMS Builder
Last Post: March 18, 2011   (RSS)

By grauchut - June 17, 2008

Help. I am just upgraded to the newest version and I cannot log in. I get this message.

MySQL Error: Table 'emerg008_cleona.cms__accesslist' doesn't exist
Glenn Rauchut (Owner) Emergency Designz

Re: [grauchut] MySQL Error HELP

By Dave - June 17, 2008

Hi Glenn,

Make sure you uploaded this file:

/data/schema/_accesslist.ini.php

And feel free to email me FTP and CMS login details to dave@interactivetools.com (email, don't post login details in forum) and I can take a look.

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] MySQL Error HELP

By Dave - June 18, 2008

This issue was resolved. For anyone following this here's how I fixed it:

First I made sure /data/schema/_accesslist.ini.php had been uploaded (it had).

Then I added this line (in red) to admin.php:

require_once "lib/init.php";
require_once "lib/admin_functions.php";

createMissingSchemaTablesAndFields();



Then I accessed admin.php. It said "creating missing tables", so I removed the above line and everything worked.

What the createMissingSchemaTablesAndFields() function does is check all the schema files in /data/schema/ and recreates the MySQL tables for them if they don't exist.

If anyone runs into this problem or anything similar let me know.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] MySQL Error HELP

By MercerDesign - March 18, 2011 - edited: March 18, 2011

Hi. Iam having the same problem on this url: http://www.motorsport-hospitality.com/cmsAdmin/admin.php?

I have tried your suggestion but it didn't work, the file /data/schema/_accesslist.ini.php has been uploaded.

I have attached the ftp details.

Re: [MercerDesign] MySQL Error HELP

By Dave - March 18, 2011

Hi MercerDesign,

Careful not to post your FTP info as this is a public forum. Can you send your details to support@interactivetools.com and we'll sort it out for you? Thanks!
Dave Edis - Senior Developer
interactivetools.com