mySql problem (I think)

I have a problem with my Spip-based site. I don't know exactly what
the problem is. I am no expert on php (or mySql) - but I can follow
simple instructions :slight_smile:

My site has a communication problem. All the cached text from Spip is
visible to the public but nothing from the database: no images and
none of the older articles. Also the search-function doesn't work and
- most importantly - I cannot access the private area. It seems to me
there's a database (perhaps a priviledge?) problem. The strange thing
is that it happened all of a sudden and I have not changed anything.

When I try to access the private area I get various error messages.
Such as "1045 Access denied for user: 'root@localhost' (Using
password: NO)"
I have also received the standard "500 Internal Server Error. The
server encountered an internal error or misconfiguration and was
unable to complete your request." And the message from Spip that "A
technical problem (mySql Server) prevents access to this part of the
site".

These messages can all mean different things and I cannot find any
information on them on Spip.net.

I have tried to delete the file "inc_connect" as well as the
".htaccess" to see if I can re-install my Spip. It does not help. When
I then try to go to ../ecrire it sends me to ../ecrire/install.php3
which seems right but the page is totally blank.

I have ftp-access and acess to the mySql database via MyAdmin

As said I do not know much about mySql-programming. I have taken a
backup of the mySql database (via "export") - do you know if that is
enough for me to be sure that I won't lose any data if I try to
reinstall SPIP? I cannot take a spip-backup as I cannot enter the
private area. The .sql-file is too big to be importet via phpMyAdmin
but there's probably ways around that.

Is this description enough for anyone to guess what the problem is?
And can you answer my worries whether having a .sql-backup is enough
for me to rest assured that no data will be lost?

My version of Spip is very old. I don't know which version - it's from
2005 or 2006.

My site is: http://illegalt.mahost.org

Hi,

your site is built on SPIP 1.82d .
This version is quite stable but you should start to update to the
version 1.8.3a
(because of 2 security fixes)

You won't loose data if you reinstall SPIP (or upgrade to spip 1.83a)
: you just have to choose during the installation process the database
that was used before.

Actually, when you remove inc_connect.php3, you are redirected to the
installation process. This is the correct process, but it fails at
this step. The fact that the page is blank can be due to diverse
reasons :
- Maybe the installation file was modified so that a new installation
can't be done
- Maybe your server does not support the extension .php3 anymore

As I just said, you must install you website again.

You can find the latest build of the 1.8 branch (version [10336]) here :
http://tech-nova.fr/SPIP/spip-1.8.3-svn10336.zip

But this version will be useless if the .php3 extension isn't
supported by your server.
I have just built a version with the .php extension instead of .php3.
It can be downloaded here :
http://tech-nova.fr/SPIP/spip-1.8.3-svn10336-with-php.zip
(I used the transformation script available here :
http://www.spip-contrib.net/Script-php-pour-convertir-les)

Attention : with this tweaked version, you must use .htaccess : remove
the '#' char at the lines 43 and 44 of htaccess.txt and rename it to
.htaccess (with this rewrite rule, each link to the old installation
will be transparently redirected to the new version).
For ex. mahost.org will point to
mahost.org

Don't forget to backup your database with phpMyAdmin before any update.
And also move all your root directory in a backup directory : maybe
the core files of SPIP has been modified (in order to add a
functionality, for ex.). In a such case the upgrade will be a bit more
difficult, so you have to keep the original files.

The files that you must keep from your old installation are
mes_fonctions.php3 and mes_options.php3
You have to keep the content of IMG/ and the files that are not from
SPIP (for ex. pix/, styles-test.css, ..)
If you have a doubt, compare your installation with a fresh 1.8.2
version (http://www.spip.net/spip-dev/devel/archive/SPIP-v1-8-2.zip)

Hope it helps,

.Gilles

====================

2008/10/7 Ole Sandberg <ole.sandberg@gmail.com>:

I have a problem with my Spip-based site. I don't know exactly what
the problem is. I am no expert on php (or mySql) - but I can follow
simple instructions :slight_smile:

My site has a communication problem. All the cached text from Spip is
visible to the public but nothing from the database: no images and
none of the older articles. Also the search-function doesn't work and
- most importantly - I cannot access the private area. It seems to me
there's a database (perhaps a priviledge?) problem. The strange thing
is that it happened all of a sudden and I have not changed anything.

When I try to access the private area I get various error messages.
Such as "1045 Access denied for user: 'root@localhost' (Using
password: NO)"
I have also received the standard "500 Internal Server Error. The
server encountered an internal error or misconfiguration and was
unable to complete your request." And the message from Spip that "A
technical problem (mySql Server) prevents access to this part of the
site".

These messages can all mean different things and I cannot find any
information on them on Spip.net.

I have tried to delete the file "inc_connect" as well as the
".htaccess" to see if I can re-install my Spip. It does not help. When
I then try to go to ../ecrire it sends me to ../ecrire/install.php3
which seems right but the page is totally blank.

I have ftp-access and acess to the mySql database via MyAdmin

As said I do not know much about mySql-programming. I have taken a
backup of the mySql database (via "export") - do you know if that is
enough for me to be sure that I won't lose any data if I try to
reinstall SPIP? I cannot take a spip-backup as I cannot enter the
private area. The .sql-file is too big to be importet via phpMyAdmin
but there's probably ways around that.

Is this description enough for anyone to guess what the problem is?
And can you answer my worries whether having a .sql-backup is enough
for me to rest assured that no data will be lost?

My version of Spip is very old. I don't know which version - it's from
2005 or 2006.

My site is: http://illegalt.mahost.org
_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en