Forums

MySQL Error on upload

Permalink
Hi,

I'm just trying to do a test upload of my site to at least make sure everything is working okay before I go headlong into adding lots of content offline. However, when I import the SQL generated in my local phpmyadmin i get the error:

Error
SQL query:
--
-- Constraints for dumped tables
--
--
-- Constraints for table `QueueMessages`
--
ALTER TABLE  `QueueMessages` ADD CONSTRAINT  `queuemessages_ibfk_1` FOREIGN KEY (  `queue_id` ) REFERENCES  `queues` (  `queue_id` ) ON DELETE CASCADE ON UPDATE CASCADE ;
MySQL said: Documentation
#1005 - Can't create table 'cl33-gdv-c5.#sql-1cb7_233a13bc' (errno: 150) (Details…)


There seems to be all the tables cretaed but I don't want to assume anything until the upload is error free!

I am on version 5.7.5.3.

Thanks in advance!

Maff
 
maffp replied on at Permalink Reply
I tried the pages anyway but every page is blank white with only the following as the source code:

<!DOCTYPE html>
<html class="no-js" lang="en">
   <head>
      <meta name="viewport" content="width=device-width, initial-scale=1.0"/>
      <!-- CSS -->
      <link rel="stylesheet" href="/application/themes/gdequinox/css/normalize.css"/>


Is this likely to be related?
maffp replied on at Permalink Reply
Another point. If I clear the cache it will allow the load of one page (any page) but if I click on another it creates the blank pages mentioned above. See:http://bit.ly/1SxIf81
mlocati replied on at Permalink Reply
mlocati
It seems there are problems with table relations.

you could try the following:
1. empty all the tables on the destination mysql server
2. Add this line at the beginning of the sql file:
SET FOREIGN_KEY_CHECKS=0;
3. Add this line at the end of the sql file:
SET FOREIGN_KEY_CHECKS=1;
4. Try to re-import the sql file
mlocati replied on at Permalink Reply
mlocati
It seems there are problems with table relations.

you could try the following:
1. empty all the tables on the destination mysql server
2. Add this line at the beginning of the sql file:
SET FOREIGN_KEY_CHECKS=0;
3. Add this line at the end of the sql file:
SET FOREIGN_KEY_CHECKS=1;
4. Try to re-import the sql file
maffp replied on at Permalink Reply
Excellent, that sorted the SQL import... thanks!

Still having the other problems mentioned though. HTML generation seems to be terminating at 
<link rel="stylesheet" href="/application/themes/gdequinox/css/normalize.css"/>
. Hmmm...
maffp replied on at Permalink Reply
Okay, I turned all the caches to ON and most pages seem to be working okay. However, the grey banner on many of the pages is linking to a missing image at /c5/application/files/...etc (was at /c5/ on my WAMP installation) instead of application/files/...etc.

Also, some of the pages are linking to an incorrect stylesheet and losing all their styles (see Photoshoots and Photoshoots2>Vintage Airfield.

Any ideas why this could be happening?

Cheers peeps, you're the best!
maffp replied on at Permalink Reply
Anyone any ideas on this?

The pages with broken CSS are all on one branch of pages on the sitemap. The rendered page source code have a broken stylesheet link:
<link href="http://domain.co.uk/index.php/ccm/system/css/page/309/main.less" rel="stylesheet" type="text/css" media="all">


and other pages have the correct link 
<link href="/application/files/cache/css/gdequinox/main.css" rel="stylesheet" type="text/css" media="all">