Backing-up and Shared SSL environment

[lippeca]

This is an untouched OSC install (brand spanking new and clean!) :)

Installed in a https SSL Server in the root under /catalog

 

 

I get this error message when trying to backup:

---------------------------------

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 'fulltext,state,sectionid,mask,catid,created,created_by,created_

 

select id,title,title_alias,introtext,fulltext,state,sectionid,mask,catid,created,creat

ed_by,created_by_alias,modified,modified_by,checked_out,checked_out_time,publish_

up,publish_down,images,urls,attribs,version,parentid,ordering,metakey,metadesc,ac

cess,hits from jos_content

 

[TEP STOP]

---------------------------------

 

but still a backup file is created as if all was OK (kindda!). If I bypass the error by using browser's back button I get this:

 

 

Database Backup Manager

 

Title Date Size Action

db_lippe_ca_01-20070405092237.sql 04/05/2007 09:22:37 139,588 bytes

db_lippe_ca_01-20070405092329.sql 04/05/2007 09:23:30 139,588 bytes

db_lippe_ca_01-20070405095724.sql 04/05/2007 09:57:24 139,588 bytes

Backup Directory: /home/www/secure-ssl.net/lippe.ca/catalog/admin/backups/

 

-----------------------------------

 

Since I am still testing the whole thing, I have only 3 products and three Customers for tax and shipping purpose for now.

So I tried to Restore the latest backup and got this :

 

-----------------------------------

 

064 - 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 'mediumtext not null , state tinyint(3) default '0' not null ,

 

create table jos_content ( id int(11) unsigned not null auto_increment, title varchar(100) not null , title_alias varchar(100) not null , introtext mediumtext not null , fulltext mediumtext not null , state tinyint(3) default '0' not null , sectionid int(11) unsigned default '0' not null , mask int(11) unsigned default '0' not null , catid int(11) unsigned default '0' not null , created datetime default '0000-00-00 00:00:00' not null , created_by int(11) unsigned default '0' not null , created_by_alias varchar(100) not null , modified datetime default '0000-00-00 00:00:00' not null , modified_by int(11) unsigned default '0' not null , checked_out int(11) unsigned default '0' not null , checked_out_time datetime default '0000-00-00 00:00:00' not null , publish_up datetime default '0000-00-00 00:00:00' not null , publish_down datetime default '0000-00-00 00:00:00' not null , images text not null , urls text not null , attribs text not null , version int(11) unsigned default '1' not null , parentid int(11) unsigned default '0' not null , ordering int(11) default '0' not null , metakey text not null , metadesc text not null , access int(11) unsigned default '0' not null , hits int(11) unsigned default '0' not null , PRIMARY KEY (id), KEY idx_section (sectionid), KEY idx_access (access), KEY idx_checkout (checked_out), KEY idx_state (state), KEY idx_catid (catid), KEY idx_mask (mask) )

 

[TEP STOP]

 

1146 - Table 'lippe_ca_01.sessions' doesn't exist

 

select count(*) as total from sessions where sesskey = 'fd51d1b4871ea5456e3924a57d10a556'

 

[TEP STOP]

 

----------------------------------------

 

This is and untouch OSC Install other than regional setup and taxes, does any of this comes from the SHARED SSL setup or did I missed any backup vs. database config ?

 

thanks for your help ?