|
|
|
|
 Re: Geo-Location Issue [message #159243 is a reply to message #159230] |
Thu, 14 May 2009 17:30   |
nozafc
Messages: 75
Registered: April 2009
Karma: 0
|
Member |
|
|
| naudefj wrote on Thu, 14 May 2009 06:55 | Ask your hosting provider to increase the upload_max_filesize setting in php.ini.
If they cannot, upload the file to the server, cut and paste the loading code from admgeoip.php and run it manually.
Best of luck.
Frank
|
Thanks for the tip
My webhost wouldn't adjust the setting but I found an easy way to do it. I commented out the line
q("DELETE FROM ".$DBHOST_TBL_PREFIX."geoip");
in the admgeoip.php file which then allowed me to upload the split csv files
Thanks for the info anyway :toppa: , without it I'd never have thought about doing it that way 
[Updated on: Thu, 14 May 2009 17:31] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Geo-Location Issue [message #164178 is a reply to message #164175] |
Fri, 07 January 2011 17:37 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
You mentioned a patch for FUD2Go MySQL, and SQLite to support cross database export/imports here:
http://fudforum.org/forum/index.php?t=msg&th=119222&goto=162127& ;#msg_162127
But it was apparently never completed, would this still be current?
Index: install/www_root/adm/admimport.php
===================================================================
--- install/www_root/adm/admimport.php (revision 4928)
+++ install/www_root/adm/admimport.php (working copy)
@@ -196,6 +189,14 @@
// Reverse formatting applied in admdump.php.
$line = str_replace('\n', "\n", $line);
+ // Handle different quote styles between databases for cross-database export/imports.
+ // For example, change \' --> '' (MySQL's --> SQLite or pgSQL)
+ if (__dbtype__ == 'mysql') {
+ $line = str_replace("''", "\'", $line);
+ } else {
+ $line = str_replace("\\'", "''", $line);
+ }
+
if (($line = trim($line))) {
if ($line{0} != '(') {
if ($tmp && !$skip) {
If so I'd be willing to give it a test and see, having that functionality for FUDforum2go
Would seem like a necessity if you are going to use it.
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
|
|
|
|
| Re: Geo-Location Issue [message #164207 is a reply to message #164179] |
Sun, 09 January 2011 15:47 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
naudefj wrote on Fri, 07 January 2011 11:53If I remember correctly a variation of that patch was eventually committed.
Best would be to just test it. If it doesn't work, we can always prepare another patch.
Ok I tried it again using a 4 GB thumb drive with no joy!
Errors mentioned last time were: "Errors on page" and "done but with errors on page"
Upload timed out after 30 seconds: Fatal error: Maximum execution time of 30 seconds exceeded in G:\FUDforum2Go testing\htdocs\include\theme\default\db.inc on line 100
Changed same to 3 minutes and retried:
Fatal error: Uncaught exception 'Exception' with message '(G:\FUDforum2Go testing\htdocs\include\theme\default\db.inc:101<br /> G:\FUDforum2Go testing\htdocs\include\theme\default\db.inc:108<br /> G:\FUDforum2Go testing\htdocs\adm\admgeoip.php:144<br /> ) 23000: columns ips, ipe are not unique<br /> Query: INSERT INTO fud30_geoip (ips, ipe, cc, country) VALUES('417800192','417808383','bs','BAHAMAS')<br /> _POST: array ( 'S' => '33d8c0899c1ea85a2eefd772f4db7b56', 'SQ' => 'ec3b60355bbcb09af8ce6f8ee9daac4b', 'format' => 'IP2C', 'btn_submit' => 'Upload IP Database', )<br /> Database version: 3.3.7undefined<br /> [Referring Page] http://127.0.0.1:4001/adm/admgeoip.php<br /> ' in G:\FUDforum2Go testing\htdocs\include\core.inc:215 Stack trace: #0 G:\FUDforum2Go testing\htdocs\include\theme\default\db.inc(101): fud_sql_error_handler('INSERT INTO fud...', 'columns ips, ip...', '23000', '3.3.7undefined') #1 G:\FUDforum2Go testing\htdocs\include\theme\default\db.inc(108): uq('INSERT INTO fud...', 1) #2 G:\FUDforum2Go testing\htdocs\adm\admgeoip.php(144): q('INSERT INTO fud...') #3 {main} thrown in G:\FUDforum2Go testing\htdocs\include\core.inc on line 215
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]