I have huge problems with changing from one database server to
another. My web hotel decided to move my mysql server, but without
moving my data, so I had to do that my self.
Now I have uploaded a backup to the new server and changed the info in
inc-connect.php, but when I log in to SPIP, which I can, It doesn't
show my articles except one article still in editing (not published).
I'm quite stupid when I comes to mysql, I can't understand, what I'm
doing wrong.
I have huge problems with changing from one database server to
another. My web hotel decided to move my mysql server, but without
moving my data, so I had to do that my self.
Hm! Start looking for another service provider!
Now I have uploaded a backup to the new server
How did you do this, Lars? Using PHPMyAdmin, or using the built in backup system in SPIP?
> changed the info in inc-connect.php
Are you sure the file is pointing to the right database?
Can you look at the database with some direct MySQL tool (PHPMyAdmin or other)? Can you see all the SPIP tables with that?
Lars Gaardsøe wrote:
I made the backup with phpmyadmin. Actually I just forgot, that spip has a fine built in backup system. Anyway, I also uploaded the backup to the new server with phpmyadmin.
As far as I can tell inc_connect.php points a the right database, and when I look it up in phpmyadmin it contains all the spip tables.
If inc_connect.php doesn't open the right database, how come I can log in. Isn't user name and password stored in the database?
- - -
Lars - please always reply to the *newsgroup*, someone else may have an idea!
config\connect.php should contain a line like this :
where the last element is the name of the database. Does it have the correct name?
If so, do you see the spip articles and sections in the "private area" of SPIP when you log in to it?
If it does not have the correct database name, the best thing to do is to delete the connect.php file and go with a navigator to your_site.com/ecrire and reinstall SPIP's database connection.
Now I have the database up and running - meaning that the « private area » works, but the site it self does not.
Then I try to visit the site, both articles and sections, I only get at blank page (You can try this here: www.ungeren.dk/index.html) and I have no idea why.
/larsg
At first browse your database to see if you have your articles inside your tables,
I mean, check if the tables contain data.
And just a quick note: Are you sure that you did not upgraded ? Is the new site a
COPY and not a new Installation (with a different version)?
If you have a mes_fonctions.php file check for a syntax error in it.
George
Lars Gaardsøe wrote:
Hello again
Thanks for all your responses.
Now I have the database up and running - meaning that the "private area" works, but the site it self does not.
Then I try to visit the site, both articles and sections, I only get at blank page (You can try this here: www.ungeren.dk/index.html <http://www.ungeren.dk/index.html>\) and I have no idea why.
I had a same problem with 2 SPIP sites. I had access to the
ecrire but the public area did not showed up. I did an upgrade to
the latest version (1.9.2b) and it solved. If you still have this problem
I suggest you to upgrade.
Jadi
Iran
Lars Gaardsøe wrote:
Hello again
Thanks for all your responses.
Now I have the database up and running - meaning that the « private area » works, but the site it self does not.
Then I try to visit the site, both articles and sections, I only get at blank page (You can try this here: www.ungeren.dk/index.html) and I have no idea why.
Do you really use a custom template or do you only use the dist templates ?
.Gilles
---
2007/6/20, George Kandalaft <george@diwanalarab.com>:
If you have a mes_fonctions.php file check for a syntax error in it.
George
Lars Gaardsøe wrote:
> Hello again
>
> Thanks for all your responses.
>
> Now I have the database up and running - meaning that the "private
> area" works, but the site it self does not.
>
> Then I try to visit the site, both articles and sections, I only get
> at blank page (You can try this here: www.ungeren.dk/index.html
> <http://www.ungeren.dk/index.html>\) and I have no idea why.
>
> /larsg
>
Do you really use a custom template or do you only use the dist templates ?
.Gilles
---
2007/6/20, George Kandalaft <george@diwanalarab.com>:
> If you have a mes_fonctions.php file check for a syntax error in it.
>
> George
>
> Lars Gaardsøe wrote:
>
> > Hello again
> >
> > Thanks for all your responses.
> >
> > Now I have the database up and running - meaning that the "private
> > area" works, but the site it self does not.
> >
> > Then I try to visit the site, both articles and sections, I only get
> > at blank page (You can try this here: www.ungeren.dk/index.html
> > <http://www.ungeren.dk/index.html>\) and I have no idea why.
> >
> > /larsg
> >
>
> _______________________________________________
> spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en
>
_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en
