<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Administrator Login Problems after PHP &amp; MySQL upgrade"]]></title>
		<link>https://proxy2.de/forum/posts/list/5.php</link>
		<description><![CDATA[Latest messages posted in the topic "Administrator Login Problems after PHP &amp; MySQL upgrade"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Administrator Login Problems after PHP &amp;amp; MySQL upgrade</title>
				<description><![CDATA[ This is the story on how I upgraded AG from version 2.2 to version 2.3.4...<br /> <br /> ...so I had AG 2.2...<br /> <br /> === PROBLEM: ===<br /> Sunddenly my Admin Password didn'y work any more,<br /> I knew from my hosting provider that they just upgraded mySQL from v. 4.0 to 4.1.x and PHP from version 4.3.x to 4.4.x. <br /> <br /> They tried to solve access problem "changing format of passwords with one compatible",  so I was able to enter... but whenever I click on every menu item it brings me back to login page !<br /> <br /> Same problem of 4664 post.<br /> <br /> So I tried to change LAST_VISIT field of the book_auth table in the database as int (11). <br /> It didn't work. So I setted again as TIMESTAMP.<br /> <br /> Looking at post  5001 I tried www.carbonize.co.uk/reset.zip but it returned an error that it was unable to reset passwords (SQL pw was absolutely correct, otherwise the error is different).<br /> <br /> Then I tried  to reset with SQL:<br /> delete from book_auth;<br /> INSERT INTO book_auth VALUES (1, 'test', '773359240eb9a1d9', '7d8b85294e2e060b83f596a4fc5561ce', 1058460506);<br /> <br /> It resetted password... but unable to use "test" "123", so I tried again with <br /> www.carbonize.co.uk/reset.zip AND IT RESETTED PASSWORD TO MY ONES.<br /> <br /> But the first problem wasn't fitted, no way to use Easy Admin and the other ADMIN menu items.<br /> <br /> === SOLUTION: from 2.2 to 2.3.1 ===<br /> Upgrade to 2.3.1 version....   IT WORKS FINE !<br />  <img src="https://proxy2.de/forum//images/smilies/283a16da79f3aa23fe1025c96295f04f.gif" /><br /> <br /> <br /> Since I was already working on it I decided to upgrade to 2.3.4.<br /> Again appeared the Administrator Problem... <br /> <br /> === SOLUTION: from 2.3.1 to 2.3.4 ===<br /> THIS TIME trying to change LAST_VISIT field of the book_auth table in the database as int (11), I got back my Administrator Control...<br /> <br />  <img src="https://proxy2.de/forum//images/smilies/385970365b8ed7503b4294502a458efa.gif" />]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/5073/18288.php</guid>
				<link>https://proxy2.de/forum/posts/preList/5073/18288.php</link>
				<pubDate><![CDATA[Tue, 4 Oct 2005 23:37:51]]> GMT</pubDate>
				<author><![CDATA[ bob4u]]></author>
			</item>
			<item>
				<title></title>
				<description><![CDATA[ Hmmmm something odd there as 2.3.x should not work with 2.2 database. You should get logged out as soon as you click a link in Admin.]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/5073/18292.php</guid>
				<link>https://proxy2.de/forum/posts/preList/5073/18292.php</link>
				<pubDate><![CDATA[Wed, 5 Oct 2005 09:54:17]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
	</channel>
</rss>