speakparrot Posted December 11, 2007 Share Posted December 11, 2007 I'm totally stumped here - Any help at all would be *greatly* appreciated. I'm working on an image gallery which utilizes a PHP script to access the database to pull the artists id and therefore pulls their main photo to display. However, when trying to view any photo it shows the "image not found" icon. The images are all on the server with all the correct permissions. I, for the life of me cannot figure out why the images are not displaying (all file paths are correct). One issue that may be related - The site's previous developer sent me the MySQL dump, which is too large to import, therefore I'm using BigDump. It does fine until it gets to the end of the file and gives the error: Query: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; MySQL: Variable 'sql_mode' can't be set to the value of 'NULL' And yes the databases are different versions. Any suggestions??????? Quote Link to comment Share on other sites More sharing options...
fenway Posted December 11, 2007 Share Posted December 11, 2007 Do you have access to the old server? if you, grab the sql mode string from there. Quote Link to comment Share on other sites More sharing options...
speakparrot Posted December 11, 2007 Author Share Posted December 11, 2007 Unfortunately I don't have access to the old server. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 12, 2007 Share Posted December 12, 2007 Then you're in trouble... what version was the old server running? You need to get the modes, or hope that it's the default (gulp). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.