|
|
 |
 | duplicate column 'propay' when upgrading to 2.3 from 2.2 |  |
 Posted: Wed Nov 12, 2003 7:28 am |
 |
|
| klaussr |
| Visitor |
|
|
| Joined: 10 Nov 2003 |
| Posts: 23 |
|
|
|
|
|
 |
|
this is what I get when running upgrade_from_2.2_to2.3.php:
| Quote: | Warning!
The following error occured:
MySQL Error: Duplicate column name 'propay'
The script is now halted.Please contact the webmaster |
when I run it the first time I hadn't uploaded the big sql file (5mb) and the other ip*.*.php files in radmin folder.
after uploading them, I run again the upgrade and that's the error I get. |
|
|
|
|
| Posted: Wed Nov 12, 2003 7:29 am |
|
|
| daniel |
| Addict |
|
|
| Joined: 19 Sep 2004 |
| Posts: 177 |
|
|
|
|
|
|
|
that means you are ready to go:)
Just run the radmin/database_load.php file now and you are ready.
Best regards,
D. |
|
|
|
|
| fixed | |
| Posted: Wed Nov 12, 2003 7:45 am |
|
|
| klaussr |
| Visitor |
|
|
| Joined: 10 Nov 2003 |
| Posts: 23 |
|
|
|
|
|
|
|
| I deleted the 'propay' field from users table and run it again the upgrade and everthing looks fine now. |
|
|
|
|
| .. | |
| Posted: Wed Nov 12, 2003 7:54 am |
|
|
| klaussr |
| Visitor |
|
|
| Joined: 10 Nov 2003 |
| Posts: 23 |
|
|
|
|
|
|
|
| do I have to run both ip2country.sql and ip2country.sql.gz ? or just the .sql ? |
|
|
|
|
| Posted: Wed Nov 12, 2003 8:19 am |
|
|
| daniel |
| Addict |
|
|
| Joined: 19 Sep 2004 |
| Posts: 177 |
|
|
|
|
|
|
|
| just the .gz file...after install,you can delete them both |
|
|
|
|
| something went wrong | |
| Posted: Wed Nov 12, 2003 8:25 am |
|
|
| klaussr |
| Visitor |
|
|
| Joined: 10 Nov 2003 |
| Posts: 23 |
|
|
|
|
|
|
|
I did run first the .sql first and when try to run the .gz it doesn't run it says that ip2country table is already created.
now when I go to see a user's statistics I get this php error:
| Quote: | | Fatal error: Call to undefined function: iptocountry() in /home/myusername/public_html/rusers/statistics.php on line 39 |
and since the first error when 'script was halted' I haven't been able to ftp to the site, it hungs at the end when listen files after taken user/passw. 
should I delete the ip2country and run the .gz file? the .sql took long time with 42000 records |
|
Last edited by klaussr on Wed Nov 12, 2003 8:35 am; edited 1 time in total |
|
|
|
| Posted: Wed Nov 12, 2003 8:31 am |
|
|
| daniel |
| Addict |
|
|
| Joined: 19 Sep 2004 |
| Posts: 177 |
|
|
|
|
|
|
|
that means you already created the iptocountry table.
you have to upload the new lib files too -they contain the "missing" iptocountry() function. |
|
|
|
|
| .. | |
| Posted: Wed Nov 12, 2003 8:58 am |
|
|
| klaussr |
| Visitor |
|
|
| Joined: 10 Nov 2003 |
| Posts: 23 |
|
|
|
|
|
|
|
ok finally I got ftp to work again, something weird was preventing me to access the site.
now after uloading all the libraries I tryed to login with the only user I have created and somehow it bounces me back to the login page. I went to admin page and the user is fine, got not idea why is doing that.
so I can't see if the statistics are ok or not. |
|
Last edited by klaussr on Wed Nov 12, 2003 9:00 am; edited 1 time in total |
|
|
|
| Posted: Wed Nov 12, 2003 8:59 am |
|
|
| daniel |
| Addict |
|
|
| Joined: 19 Sep 2004 |
| Posts: 177 |
|
|
|
|
|
|
|
| Please try a promo.php?from=admin url first:) |
|
|
|
|
| .. | |
| Posted: Wed Nov 12, 2003 9:05 am |
|
|
| klaussr |
| Visitor |
|
|
| Joined: 10 Nov 2003 |
| Posts: 23 |
|
|
|
|
|
|
|
| I didn't quite understood that about promo.php |
|
|
|
|
|
|
