Transfer from localhost to Server

phwhitfield · Post by **phwhitfield** » Mon 25. Apr 2005, 09:42

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:

Code: Select all

TYPE=MyISAM AUTO_INCREMENT=1 ;

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

phwhitfield · Post by **phwhitfield** » Mon 25. Apr 2005, 12:02

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?

pico · Post by **pico** » Mon 25. Apr 2005, 12:52

Hi

did you change the table_pretend maybe?

phwhitfield · Post by **phwhitfield** » Mon 25. Apr 2005, 13:02

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...

phwhitfield · Post by **phwhitfield** » Tue 26. Apr 2005, 12:05

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?

pico · Post by **pico** » Tue 26. Apr 2005, 14:47

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

phwhitfield · Post by **phwhitfield** » Tue 26. Apr 2005, 16:59

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]

Peekay · Post by **Peekay** » Tue 26. Apr 2005, 23:04

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.

phwhitfield · Post by **phwhitfield** » Wed 27. Apr 2005, 10:36

Hi

I tried it. But it doesn't work either. This is how it looks like right now:

Peekay · Post by **Peekay** » Wed 27. Apr 2005, 11:58

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.