|
Author
|
Message
|
|
John Mina
|
Sunday 06 August 2006 4:50:48 am
hello,
Since a week ago , the database just had a problem and since that day we as admins are not abel to log in as admins for adding articles. The site is using version 3.4.1 ,
I tried to install a backup of and old db backup for the users tables and rights of the site in order to allow me to log in
but it is still the same
when i login it return m back to the login bage, and i am not able to reach the setup part or any section even if iwrite the path .
And when i use a wrong username and/or password the system says i used a wrong one and ask me for a correct one.
but when i use the correct one it just do nothing .
Can some one help me please please please
that is very Urgent
thanks
John Mina
|
|
Paul Borgermans
|
Sunday 06 August 2006 1:38:07 pm
Hi John I think you are bitten by the reference bug of PHP4.3. But the 3.4 branch is really old now (even unsupported), is there no option to upgrade to 3.7 (3.8 is also good, but requires more upgrade steps)? Can you tell us a bit more on what may have changed before/after you experienced this? There may be some other bugs that hit you and maybe we can help with more info --paul
eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans
|
|
John Mina
|
Tuesday 08 August 2006 12:00:54 am
hi Paul,
I appreciate it a lot your reply.
The Version 3.4.1 could be upgraded but my php version on the server is 4.3.6 so i think i can't update the system to 3.7 which requires PHP 4.4.x
Please let me know
Awaiting your reply
thanks
John NOTE: i didn't do any updates before i have this thing. the main problem is that i was on vacation, and the site was ok , i came back i found it down and since then it is down :(
|
|
Kristof Coomans
|
Tuesday 08 August 2006 12:08:07 am
I think restoring a database backup is the best option. Good luck!
independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org
|
|
John Mina
|
Tuesday 08 August 2006 12:21:21 am
the latest i have is about 2 months ago
editors will kill me if i said that :)
no other options u may think of ?
|
|
John Mina
|
Tuesday 08 August 2006 3:32:48 am
Hello Kristo, hello paul.
I made a full database update and site update but i faced the same problem
Also i faced the problem that i am not able to run some commands for updating , i get warning nd error messges when i run the ./update/common/scripts/updateiscontainer.php What do you think ?
|
|
Marcin Drozd
|
Tuesday 08 August 2006 4:15:57 am
Hi
I had a similar problem with login one year ago.
My database table (ezsession) was disrepair.
I deleted one and created a new one, and it worked.
Backup, update - nothing helped.
http://ez-publish.pl
|
|
John Mina
|
Tuesday 08 August 2006 4:22:44 am
how to recreate a new one
do you have the SQL statements ?
|
|
John Mina
|
Tuesday 08 August 2006 4:46:23 am
Marcin,
You are great , thanks a lot and i don't know hwo to thank you actually.
The problem has been totally solved now
the sql statements for that table are :
CREATE TABLE ezsession (
session_key varchar(32) NOT NULL default '',
expiration_time int(11) unsigned NOT NULL default '0',
data longtext NOT NULL,
user_id int(11) NOT NULL default '0',
PRIMARY KEY (session_key),
KEY expiration_time (expiration_time),
KEY ezsession_user_id (user_id)
) TYPE=MyISAM;
ope that may help other users to solve thier problems
|
|
Marcin Drozd
|
Tuesday 08 August 2006 4:47:12 am
I use phpmyadmin for mysql operation on databases.
Phpmyadmin will tell you if the table is disrepair.
I dont know what does ezsession looks like in eZp version 3.4.1
but this is code for eZp 3.8.3:
CREATE TABLE `ezsession` (
`data` longtext NOT NULL ,
`expiration_time` int( 11 ) NOT NULL default '0',
`session_key` varchar( 32 ) NOT NULL default '',
`user_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `session_key` ) ,
KEY `expiration_time` ( `expiration_time` ) ,
KEY `ezsession_user_id` ( `user_id` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
http://ez-publish.pl
|
|
Marcin Drozd
|
Tuesday 08 August 2006 4:49:29 am
:)
1 minute too late :)
Great
You are welcome :)
http://ez-publish.pl
|
