Admin Login Problem with 3.0.13 upgrade

[Guest fleer_allstar]

I just manually upgraded to .13 and now I cannot login my Admin section?

MySQL Error Occured

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND blockTime < 1161130567' at line 1



QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = 'houstonaxl' AND password = 'e7ffec49eb01e2dab35c19fe5b6969a1' AND failLevel < AND blockTime < 1161130567

this is what I get when I try to log in?

did I miss something or do I need to change something in my database? This is my first Manual upgrade to CC but as far as I can tell the retail side works ok with the exception of RandomProduct Images won't show I had modded that with the Scrolling PopularProducts with Images so I'll try to fix it later...But I need to login to my Admin?!?!?!

Anyone else have this problem or can someone tell me how to fix it or even offer to fix it for me?????

HELP! :(

[Guest]

a URL would be handy and the text in global.inc.php, but please remove any user names and passwords before you post this info :(

[Robsta]

Shouldn't this be in the CC3 section?

[roban]

Shouldn't this be in the CC3 section?

Good thinking! Moved

[Guest adman]

a URL would be handy and the text in global.inc.php, but please remove any user names and passwords before you post this info

I too am having the same problem. This is my global.inc and nmy url is www.artclaynz.co.nz/store

any help would be great

<?php

$glob['dbdatabase'] = 'artclay_store';

$glob['dbhost'] = 'localhost';

$glob['dbpassword'] = ;

$glob['dbprefix'] = '';

$glob['dbusername'] = 'artclay_forum';

$glob['installed'] = '1';

$glob['rootDir'] = '/home/artclay/public_html/store';

$glob['rootRel'] = '/~artclay/store/';

$glob['storeURL'] = 'http://artclaynz.co.nz/store';

?>

[Guest behosted]

having the same problem

MySQL Error Occured

1054: Unknown column 'failLevel' in 'where clause'

QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = 'admin' AND password = 'b73292a282834896eb85492c93e308d1' AND failLevel < 5 AND blockTime < 1166004000

I added then the failLevel and blockTime to that table

and now I got

MySQL Error Occured

1146: Table 'goede_cube3.CubeCart_blocker' doesn't exist

QUERY = DELETE from CubeCart_blocker WHERE lastTime<1166001192

Before I go further, is there any script to update the db with the right tables and stuff?

I upgraded from 3.0.7 to 3.014

[roban]

<?php

$glob['dbdatabase'] = 'artclay_store';

$glob['dbhost'] = 'localhost';

$glob['dbpassword'] = ;

$glob['dbprefix'] = '';

$glob['dbusername'] = 'artclay_forum';

$glob['installed'] = '1';

$glob['rootDir'] = '/home/artclay/public_html/store';

$glob['rootRel'] = '/~artclay/store/';

$glob['storeURL'] = 'http://artclaynz.co.nz/store';

?>

$glob['rootRel'] = '/store/';

[Guest behosted]

I did the following upgrades :

3.0.{6-10}-3.0.11

after that

3.0.11-3.0.12

and then

3.0.12-3.0.13

But still get

MySQL Error Occured

1146: Table 'goede_cube3.CubeCart_blocker' doesn't exist

QUERY = DELETE from CubeCart_blocker WHERE lastTime<1166004879

[edit]

Ok Got it working

missed this post

http://www.cubecart.com/site/forums/index....showtopic=23229

[/edit]

[Guest]

I upgraded from 3.06 and get this:

MySQL Error Occured

1054: Unknown column 'failLevel' in 'where clause'

QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = 'XXXX' AND password = 'XXXXXXXXXXXXXXXXXXXXXXXX' AND failLevel < 5 AND blockTime < 1166114223

What should I do now?

Should I go back and upgrade 1 by 1?

The store is working, I just can't get into the admin side of things....

[Guest KPalicz]

I am having the same problem and I am using 3.0.15

nm, I figured it out.

[Guest]

What did you do??

I am having the same problem and I am using 3.0.15

nm, I figured it out.

[Guest]

Every thing alright now, I didn't do the upgrade.php scripts!! Gotta read the instructions...all works great now.