Форумы / Cotonti / Bugs / Reports / 0.9.3 Bugs

12>>>

Trustmaster
#1 03.07.2011 08:43

Make sure to update the database too by running install.php as described in this article.

May the Source be with you!
Hakou
#2 03.07.2011 08:44

I did run install.php, it just redirected me to my page though. Is it supposed to show something when I upgrade it running install.php?

pieter
#3 03.07.2011 09:24
... can we help you ...
Hakou
#4 03.07.2011 21:10

Okay when I go into install.php ... it tells me to put my sql password and I did but then I get an error saying:

 

Fatal error: SQL error 42S01: Base table or view already exists: 1050 Table 'cot_auth' already exists

#0  cot_diefatal(SQL error 42S01: Base table or view already exists: 1050 Table 'cot_auth' already exists) called at [/home/topmv/public_html/system/database.php:436]
#1  CotDB->query(/**
 * Version: 0.9.3
 */
and a bunch of mysql lines after that. How do I fix this?
Trustmaster
#5 04.07.2011 06:20

It seems like it is trying to perform a new install rather than upgrade. Can you find $cfg['new_install'] in your datas/config.php and tell us what value it has?

May the Source be with you!
Hakou
#6 04.07.2011 08:03

I never edit the data/config.php so I'm not sure if I have to change it for the update. Should probably mention that in the tutorial if you have to just as a reminder. But it shows:

 

$cfg['new_install'] = 1;	
I'm assuming I have to change it to "0" instead of the proposed "FALSE" that it tells you to on the data/config.php page?
pieter
#7 04.07.2011 08:10

Before the upgrade procedure was automatic. You needed to replace ALL files also the config.php.
Problem is that nobody does this. (Me included)

And then you got those problems.
 

Use the config.php from the downloaded 0.9.3.
Fill all in and change the 1 into a 0.

But start from your side BEFORE you tried to upgrade. Otherwise you can get a corrupted database.

... can we help you ...
Hakou
#8 04.07.2011 08:21

Hey thanks pieter, but I don't get what you mean by "But start from your side BEFORE you tried to upgrade."

pieter
#9 04.07.2011 11:26

Don't try to REDO a upgrade. Restore your backup and try the upgrade again.

... can we help you ...
Hakou
#10 05.07.2011 05:51

I did everything and finally got that update page to load but I get the following error on top of the update page:

 

Warning: Invalid argument supplied for foreach() in /home/topmv/public_html/modules/install/inc/install.update.php on line 270
Trustmaster
#11 05.07.2011 11:17

That's not critical, your site should work after that.

May the Source be with you!
Hakou
#12 05.07.2011 15:24

Having major problems. The theme won't show up and it keeps changing the url to "http://localhost/" which is what I'm assuming messing up the theme. I replaced the 0.9.2 config with the 0.9.3 version and replaced the mysql information and kept "$cfg['mysqlhost'] = 'localhost';" the same as it is as it worked just fine. I honestly don't know what I'm doing wrong here.

pieter
#13 05.07.2011 16:18

Have you changed in config.php $cfg['mainurl'] = 'http://localhost'; to $cfg['mainurl'] = 'http://www.yoursite.com';

Do you have a link?

I sended you a PM

... can we help you ...
Отредактировано: pieter (05.07.2011 16:25, 13 лет назад)
Hakou
#14 05.07.2011 16:36
#30076 pieter:

Have you changed in config.php $cfg['mainurl'] = 'http://localhost'; to $cfg['mainurl'] = 'http://www.yoursite.com';

That fixed my problem. Thanks.
pieter
#15 05.07.2011 16:38

Is everything solved now after completing the upgrade?

... can we help you ...

12>>>