mysql errror NOT NULL on WAMP5 restore|Old Forum|Forum Archive|XCloner

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_TopicIcon
mysql errror NOT NULL on WAMP5 restore
July 19, 2007
12:00 am
Avatar
margaret hunnicutt
Guest
Guests

Hi

Is there a different setting required to backup a site that will be restored to MAMP as opposed to WAMP? The backup is coming off a unix server.

I can easily download and restore my clone to my MAMP server on my mac. I'm attempting to do the same thing onto a WAMP5 server (which I'm new to) and restoring is no where near as easy for me.

With the MAMP, everything runs from the menu and the restore works perfectly.
With the WAMP, it seems I have to do the extract manually, and then when I attempt to restore just the database via the JCphp, I get this error:

##Mysql Query:
########- Safe_Mode turned Off
- Open_basedir set to No Value
- *depending on your site size, you will need to make sure you can increase the max_execution_time variable in your php.ini to more than 30 seconds
CREATE TABLE `jos_downloads_files` ( `id` int(11) NOT NULL auto_increment, `sequence` int(11) NOT NULL default '0', `windowtitle` varchar(255) NOT NULL
... goes on and on ...
########
##Error message: The used table type doesn't support FULLTEXT indexes

##Mysql Query:
########
LOCK TABLES `jos_downloads_files` WRITE;
########
##Error message: Table 'qsolve.jos_downloads_files' doesn't exist

I use the install files directory option. I end up with 116 records in the database (on my MAMP server I end up with 117.

I have compared my php.ini settings, and they are the same -
- Safe_Mode turned Off
- Open_basedir set to No Value
- max_execution_time variable in your php.ini is 30 seconds for both.

Anyone have any ideas where I should look next? bound to be some simple setting somewhere I just don't know about yet.

Thanks in advance!

July 19, 2007
12:00 am
Avatar
Ovidiu
Guest
Guests

The problem seems to be from this mysql query, starting with

"CREATE TABLE `jos_downloads_files`"...

Could you copy/paste here the full query to see if we can fix it?

Ovidiu

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
D: 21
Andy: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10080
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Manuele Freddo_1
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0