2 of 2
2
Looping SQL errors when trying to upgrade from 1.5.2 to 1.6.3
Posted: 04 August 2008 08:12 AM   [ Ignore ]   [ # 19 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15869
Joined  06-03-2002

No, while 777 is the most “open” permissions you can grant, there are some environments running certain security software that will specifically prevent PHP from modifying files with such open permissions.

I’m still waiting for the answer to what the results are of the following, as without this knowledge, we cannot proceed to assist you:

Also, put the error_reporting() and ini_set() lines in a new PHP file with phpinfo().  The new file should just have the following:

<?php
error_reporting
(E_ALL);
ini_set('display_errors', 1);
phpinfo();


Then access that file in your browser and check the ‘display_errors’ value; it should read “On”.

 Signature 
Profile
MSG
 
 
Posted: 09 August 2008 11:03 PM   [ Ignore ]   [ # 20 ]  
Summer Student
Total Posts:  17
Joined  05-31-2008

Hi Derek,

Nothing. No errors reported. Just the same usual db errors.

Thanks,


Adrian

Profile
 
 
Posted: 10 August 2008 07:16 AM   [ Ignore ]   [ # 21 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15869
Joined  06-03-2002

Adrian, this code is supposed to go in a separate PHP file, there should be no database connectivity (or ExpressionEngine) involved.

 Signature 
Profile
MSG
 
 
Posted: 11 August 2008 06:57 AM   [ Ignore ]   [ # 22 ]  
Summer Student
Total Posts:  17
Joined  05-31-2008

Hi Derek,

That’s what I did, but again I got no errors reported. What I did get was the whole configuration list.


Adrian

Profile
 
 
Posted: 11 August 2008 07:46 AM   [ Ignore ]   [ # 23 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15869
Joined  06-03-2002

Then access that file in your browser and check the ‘display_errors’ value; it should read “On”.

What is the value of display_errors in that configuration list?

 Signature 
Profile
MSG
 
 
Posted: 13 August 2008 06:47 AM   [ Ignore ]   [ # 24 ]  
Summer Student
Total Posts:  17
Joined  05-31-2008

Yep, it’s “on.” This is why I’m even more puzzled.

Profile
 
 
Posted: 13 August 2008 08:03 AM   [ Ignore ]   [ # 25 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15869
Joined  06-03-2002

Ok, unzip and upload this to the root public directory of your domain.  Change writeme.php’s permissions to 666 and then access in your browser: http://example.com/write_test/action/

Assuming you get no errors, open writeme.php, it should now have “Hello World” written to it.

File Attachments
write_test.zip  (File Size: 1KB - Downloads: 25)
 Signature 
Profile
MSG
 
 
Posted: 16 August 2008 08:58 PM   [ Ignore ]   [ # 26 ]  
Summer Student
Total Posts:  17
Joined  05-31-2008

Hi Derek,

Yes, this file now says “Hello World” What should we do now?

Thanks,


Adrian

Profile
 
 
Posted: 16 August 2008 09:38 PM   [ Ignore ]   [ # 27 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15869
Joined  06-03-2002

It’s been over a month, so I really think it’s best that we approach this issue fresh.  If you restore and proceed through an update, does the config file still not get written to?  What if you were to do a new install on this server to a different database and location?  Is the new config file written to properly?

 Signature 
Profile
MSG
 
 
Posted: 16 August 2008 10:24 PM   [ Ignore ]   [ # 28 ]  
Summer Student
Total Posts:  17
Joined  05-31-2008

If I try to run the update, it doesn’t work. The database gets updated, but whatever else is to happen, doesn’t happen. I can imagine that if I get the set of updated files, the update is supposed to make, it’ll work.

Adrian

Profile
 
 
Posted: 17 August 2008 05:34 AM   [ Ignore ]   [ # 29 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15869
Joined  06-03-2002

What if you were to do a new install on this server to a different database and location?  Is the new config file written to properly?  There’s not any reason I can see here that the file is not updating - you aren’t getting errors, and the identical code in a standalone PHP file works.

 Signature 
Profile
MSG
 
 
Posted: 20 August 2008 07:05 AM   [ Ignore ]   [ # 30 ]  
Summer Student
Total Posts:  17
Joined  05-31-2008

The problem is, how do I do a new install with an upgrade license? and how do I do it with only one database allowed by the host? If I could get a hold of the set of files that work with 1.6.3 I would be ready to complete the upgrade.

Profile
 
 
Posted: 20 August 2008 07:53 AM   [ Ignore ]   [ # 31 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15869
Joined  06-03-2002

If your host only allows one database then you would not be able to do it.  The files you have (1.6.4 if you’ve downloaded the latest version) will work with 1.6.3, and can complete the upgrade.  But if you do not solve the problem of not being able to write to your config file, you will have problems in the future when changing certain settings, and it may also indicate related problems like cache files not being able to be written to/over, CAPTCHA not being able to create images, etc.

If you can again roll back to the 1.5.2 version of your database, and email me FTP and database access, I can take a quick look and see if there’s something being overlooked.  If the standalone script wrote to the file fine, the upgrade script should be able to do so also, again, it’s the same code, same directory structure, same permissions.

 Signature 
Profile
MSG
 
 
Posted: 23 August 2008 11:54 PM   [ Ignore ]   [ # 32 ]  
Summer Student
Total Posts:  17
Joined  05-31-2008

Can you please send me your E-mail address?

Thank you,


Adrian

Profile
 
 
Posted: 24 August 2008 01:30 AM   [ Ignore ]   [ # 33 ]  
Moderator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15488
Joined  05-15-2004

Adrian, you can contact Derek via his profile page. Actually, using “MSG” under his avatar works, too.

 Signature 

Everything will be good in the end. If it’s not good, it’s not the end.

Profile
MSG
 
 
   
2 of 2
2
 
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members: 65085 Total Logged-in Users: 40
Total Topics: 82223 Total Anonymous Users: 16
Total Replies: 441920 Total Guests: 213
Total Posts: 524143    
Members ( View Memberlist )
Newest Members:  BombermanhaimtuagocsadamVeNeaDoRHildegaardhrtrulzUNFORGIVEN IIIEmmanuelYanYanTomsB