Need someone familiar with Joomla and Mysql to help import the backup of my data for my Joomla/Virtuemart site. We had a server hard drive crash so we now have to rebuild the site and we're getting the following error when attempting to import the SQLdump file via PHPMYadmin
SQL query:
CREATE TABLE `beatspla_bpbeatsplanet`.`jos_vm_cart` (
`user_id` int( 11 ) NULL ,
`cart_content` text NULL ,
`last_updated` timestamp NULL default 'CURRENT_TIMESTAMP',
PRIMARY KEY ( `user_id` )
) TYPE = MYISAM ;
MySQL said: Documentation
#1067 - Invalid default value for 'last_updated'
I expect from this coder to successfully import/edit the SQL DB and help connect joomla to this Database without any errors or glitches.
PHP V 5.2.17