When installing Admin Secure 1.7 Final on PHPNuke 7.3 i got this error message:
Quote:
Database Error!
An error was encountered while convert existing admin account.
Error Message:
Unknown column 'lastupdate' in 'where clause' (Code: 1054)
It strongly recommended that you stop this process now. Make sure your PHP-Nuke is properly installed and configured, and your site has no database problems.
any idea??
madman Support Mod
Joined: Feb 15, 2004
Posts: 806
Posted:
Sun Jun 13, 2004 2:38 pm
Be sure $asec_dbtable in asconfig.php only containing alphanumerics (a-z), numerics (0-9) and underscores.
_________________ I'm
TrishTan Nuke Cadet
Joined: Jun 13, 2004
Posts: 2
Posted:
Tue Jun 15, 2004 8:38 am
No, thats not it... At least for me.....
madman Support Mod
Joined: Feb 15, 2004
Posts: 806
Posted:
Tue Jun 15, 2004 9:50 am
This was also happened with someone else and the error was he accidentally remove trailing doublequote on variable value. If you still got such error, open phpMyAdmin to check the 'lastupdate' field. For example, if you define 'mirror_table' assigned to $asec_dbtable in asconfig.php, select on that name from left list pane located in phpMyAdmin, create the field when absent by executing this command from phpMyAdmin sql query:
Code:
ALTER TABLE `mirror_table` ADD `lastupdate` int(11) not null default '0';
Change "mirror_table" with your actual table name defined in #asec_dbtable variable.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
