David Slack - Web developer

Drupal 6 Clone

For the last 2 hours I've been trying to clone a Drupal website. I have a site on my PC (WAMP) and some server space on a dedicated server.

Now, I uploaded all the files without incident, next came the database. Usually I'll upload using phpMyAdmin but if there is a problem I'll upload using SSH.

So, I've got a file dump of the Database and I try to upload using phpMyAdmin and get server gone away error. So I try with SSH and get the same! I check the Database and everything is fine up to the System table which is missing but "still in use"?. So, I retry the whole database without the System table, all fine.

At this point I know the System table has a problem, but what causes that?!

After some SQL writing and testing the system table it turns out the 'schema_version' field has a -1 default value when it's a SMALLINT, but, SQL falls apart with that. If I change it to a '0' instead of a '-1' its all happy.

So now the 3 questions, why did it work with '-1' on WAMP version, why was it '-1' in the first place and will me changing to '0' cause a problem?

Anyone know the answers?

Latest content

There are lots of developers out there with varying degrees of experience and expertise, some mid level, some junior and some senior. Some...
First thoughts are Symfony is ace!Only been using Symfony for 1 project but the amount of coding it has saved has been worth the time spent...
The Lost and Found website was built by myself (David Slack) and designed by Arm & Eye.The site was created to promote a bar and...

Social networks

Contact me here or catch me on one of
the social networks below


What I'm listening to

Off-site News

My blog

Wednesday, 2 August, 2017 - 06:56
There are lots of developers out there with varying degrees of experience and expertise, some mid level, some junior and some senior. Some developers...
Tuesday, 5 March, 2013 - 09:49
First thoughts are Symfony is ace!Only been using Symfony for 1 project but the amount of coding it has saved has been worth the time spent learning...
Monday, 3 December, 2012 - 10:07
As a web developer and web designer I need to take into account everything on a site from SEO, marketing, usability across devices, the look and feel...

Try this on your mobile

Use your QR reader to read this

You should be able to use this right from the screen

Latest tweets

Calendar

M T W T F S S
 
 
 
 
1
 
2
 
3
 
4
 
5
 
6
 
7
 
8
 
9
 
10
 
11
 
12
 
13
 
14
 
15
 
16
 
17
 
18
 
19
 
20
 
21
 
22
 
23
 
24
 
25
 
26
 
27
 
28
 
29
 
30
 
 

You are here

Back to top

Copyright David Slack - Web developer