David Slack - Web developer
Search:
- 29 North
- Act Maintenance Solutions
- Ady Mills
- Arm & Eye
- Documenting the Mundane
- DS Card
- Ebay shop - Tech Genome
- Elevator Studios
- ESS Newton
- Farango
- Lilly Grove
- Lost and Found
- Lucky Fingers
- Luna
- My BubbleBee
- My website
- Relish
- Rotary Club of Liverpool
- SATandCABLE
- Senua Digital
- Senua Hydroponics
- The Natural Apothecary
- Vehcam
- Wind in the Willows Child Care
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
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
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 |
|
|
|
|
|
Copyright David Slack - Web developer