Page 1 of 1
Transfer from localhost to Server
Posted: Mon 25. Apr 2005, 09:42
by phwhitfield
Hi, i tried to transfer my existing page on localhost to my server. I uploaded all files, changed conf.inc.php and exported all tablecontents with phpmyadmin. Then i tried to upload this sql with phpmyadmin on the server.
But this line:
Code: Select all
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
generated an error message (MySQL 4.1.10a). So I changed it to:
This seemed to work. I can browse thru all my tables with phpmyadmin.
The Pagelayout works to. Also the navigation.
But articles are not being displayed. Neither in back- or frontend.
Does anybody know this issue?
thanks
Posted: Mon 25. Apr 2005, 12:02
by phwhitfield
hi
I'm pretty sure now, that everything is ok with my MySQL tables. Because i generated them again from the original setup sql file without any error messages. But still there is no display of the articles.
Everything else works just fine. I also reuploaded all my files. Maybe there is something special about my php-installation?
Posted: Mon 25. Apr 2005, 12:52
by pico
Hi
did you change the table_pretend maybe?
Posted: Mon 25. Apr 2005, 13:02
by phwhitfield
hi
thanks for your reply. No i didn't change table_prepend. I can connect to my tables. Because template, menu, login and everything works. Just displaying articles doesn't...
Posted: Tue 26. Apr 2005, 12:05
by phwhitfield
I now made a completely new installation of PHPWCMS on the Server. But it is still not working. I can create a new ARticle in the backend. But i can't edit it.
Could it be that i don't have the right version of MySQL and some SQL Select command doesn't work, so that i get a blank query?
Posted: Tue 26. Apr 2005, 14:47
by pico
Hi
AFAIK you need for the 1.2.1 phpwcms-Version a SQL 4.0.2 or higher.
Did you check that all Folders and Files have the right Permissions?
Or your Path-Settings in conf.inc.php are not correct.
see here
http://www.phpwcms-docu.de/index.php?dev_1_x_de
Posted: Tue 26. Apr 2005, 16:59
by phwhitfield
Hi
i checked with my provider and it's MySQL Version 4.0.20a. So it should work. My pathsettings must be correct because all links and images work. I just don't get no content...
[/img]
Posted: Tue 26. Apr 2005, 23:04
by Peekay
I had an issue on a Win localhost installation where PHPWCMS installed fine, but no articles could be edited. The fix in this post worked.
http://www.phpwcms.de/forum/viewtopic.php?p=39107#39107
I was told there would be no need to use this on a shared server, but you may want to try it anyway.
Posted: Wed 27. Apr 2005, 10:36
by phwhitfield
Hi
I tried it. But it doesn't work either. This is how it looks like right now:
Posted: Wed 27. Apr 2005, 11:58
by Peekay
You might want to check that there are no trailing spaces after the closing PHP tag in any config file you have edited. That can stop a script running. CPanel editor can sometimes cause this problem.
I have had issues with line breaks in PHP files too. PHP files *should* be uploaded as ASCII. If you do this, the line break method used in the original file is automatically converted to the method required by the server OS. If you upload in binary mode, the original breaks are retained. This doesn't matter in most cases, but if the line breaks are not read properly, some scripts may fail. Biggest issues are when the files have been composed on an older Mac.
If you suspect there may be an issue with the SQL dump, you could try the A.M.B.T utility to create the SQL file as recommended in this thread:
http://www.phpwcms.de/forum/viewtopic.php?p=26093#26093
Only other thing I can suggest is re-install, or leave the database as it is, dump all the files and re-upload them. I have had FTP transfers corrupt files before. A new upload alone has often solved it.