EMERGENCY! HELP

8 posts by 2 authors in: Forums > CMS Builder
Last Post: January 6, 2010   (RSS)

By (Deleted User) - January 6, 2010

HI, I have your product on www.travabond.com, and no on can log in right now because I think one of the administrators tried to change the table name for the User Accounts from 'accounts' to 'user_accounts'. I am the main administrator, and when anyone tries to log on I get a MySQL error stating that "Mysql Error: Table 'cjnovak.irw_accounts' doesn't exist". Please help me resolve this, as I can't get in to the system to even try to change the name back to fix it. Thank You!

Re: [Dave] EMERGENCY! HELP

By (Deleted User) - January 6, 2010

Thanks Dave, I sent you the info. Please let me know it there's anything else you need from me.

Re: [cjnovak] EMERGENCY! HELP

By Dave - January 6, 2010

Hi cjnovak,

It should be fixed now, let me know if there's any other issues.

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

Re: [Dave] EMERGENCY! HELP

By (Deleted User) - January 6, 2010

Hi Dave,

I can log on now, but every time I try to open a table other than User Accounts, i get the error: "getRecords(accounts): Couldn't load schema for 'accounts'!".

Additionally, it appears that the 84 some user accounts for the realtors a had to upload their listing data that I previously had in the system are now gone?

Hopefully you can help resolve this, thanks.

Re: [cjnovak] EMERGENCY! HELP

By Dave - January 6, 2010

Hi Chris,

I added this code to admin.php the first time to manually rename the table:
$r = mysql_query_fetch_all_assoc("ALTER TABLE {$TABLE_PREFIX}user_accounts RENAME TO {$TABLE_PREFIX}accounts");

### Login

And then just now renamed the schema file
from /cmsAdmin/data/schema/user_accounts.ini.php
back to /cmsAdmin/data/schema/accounts.ini.php

I think that should fix it. Can you double check and let me know?

Thanks!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] EMERGENCY! HELP

By (Deleted User) - January 6, 2010

Hey Dave,

It looks like it fixed it, thanks a bunch!

Re: [cjnovak] EMERGENCY! HELP

By Dave - January 6, 2010

No problem, glad it's working again! :)

I've made a note to add some extra error checking to the next version so the accounts user table can't be accidentally renamed.
Dave Edis - Senior Developer
interactivetools.com