ROCO*AFZ* Posted June 13, 2007 Report Posted June 13, 2007 Having an issue with the dump file... my mysql doesn't like it. Error SQL query: -- phpMyAdmin SQL Dump -- version 2.10.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 12, 2007 at 07:27 PM -- Server version: 5.0.27 -- PHP Version: 4.4.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; MySQL said: #1193 - Unknown system variable 'SQL_MODE' Any thoughts?
.TuG.Beaver Posted June 13, 2007 Report Posted June 13, 2007 Having an issue with the dump file... my mysql doesn't like it. Error SQL query: -- phpMyAdmin SQL Dump -- version 2.10.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 12, 2007 at 07:27 PM -- Server version: 5.0.27 -- PHP Version: 4.4.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; MySQL said: #1193 - Unknown system variable 'SQL_MODE' Any thoughts? Hi ROCO - try editing the dbsetup.sql file & removing the line that says: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; Let me know if that works & I'll update the file to remove that line. I believe its specific to MySQL 5.
.TuG.brok21k Posted June 13, 2007 Report Posted June 13, 2007 Current known issues: -When you have invalid images. In config.php set $AURL = "/grawstats"; -Importstats.php (Error msgs) use = http://www.brok21k.co.uk/importstats.rar or use index.php -PHP 4 (index.php invalid mysql errors) *UNTESTED* use =http://www.brok21k.co.uk/index(php4).rar - Top 10 not working, use this index.php instead: http://www.brok21k.co.uk/index(tag after name).rar This is because of the tag being after the name. (which i didnt test sorry, but it should now work).
ROCO*AFZ* Posted June 13, 2007 Author Report Posted June 13, 2007 same error on both import and index files (tested both methods) The xml i am importing contains this <?xml version="1.0" encoding="ISO-8859-1" ?> - - - - - There are also a few other xmls. These are the import errors i get... 1st error, i assume 1st xml Invalid Round query: No Database Selected Whole Round query: INSERT INTO roundg VALUES ('2007-06-09 23:39','2','2','1','1','1','_786bringit','_786bringit','tdm01') File : graw-xml-data/teamdeathmatch_2.xml Loop : 0 If i refresh i get this Invalid Round query: No Database Selected Whole Round query: INSERT INTO roundg VALUES ('2007-06-11 22:48','2','1','2','0','1','sekai','','tdm01') File : graw-xml-data/teamdeathmatch_3.xml Loop : 0 and on another refresh i get this Invalid Round query: No Database Selected Whole Round query: INSERT INTO roundg VALUES ('2007-06-08 14:00','2','1','2','0','1','morphineXxX','Liamc','tdm01') File : graw-xml-data/teamdeathmatch_1.xml Loop : 1 Then i get the index with no data imported. (no stats) I hope this helps in troubleshooting
.TuG.brok21k Posted June 13, 2007 Report Posted June 13, 2007 I think your problem is due to your PHP & SQL being a lower/older version. I know your php is version 4, but what is your mysql? I will try and get some free webspace matching them versions and do some testing, please patient:blush: 1st The error msg states theres a problem with your selected database. Please check you have entered the correct database name (this can sometimes be the same as the login)
LARSA.vU Posted June 13, 2007 Report Posted June 13, 2007 Please be sure & post us a link back to your install of the stats so we can see what teams are doing with it. vU Stats PHP Version 4.4.7 Have more stats to import when i have time. As you can se we have the clan tag at the end of the playername xxxxx.vU So Top 10 .vU Players are not displayed.
.TuG.brok21k Posted June 13, 2007 Report Posted June 13, 2007 Ok, just try using vU (with out .) for now. and reduce $tablesize to 50 or 60 in config.php $tablesize = '60%';
.TuG.brok21k Posted June 13, 2007 Report Posted June 13, 2007 sorry that wont work, use this index.php instead: http://www.brok21k.co.uk/index(tag after name).rar This is because of the tag being after the name. (which i didnt test sorry, but it should now work).
LARSA.vU Posted June 13, 2007 Report Posted June 13, 2007 sorry that wont work, use this index.php instead: http://www.brok21k.co.uk/index(tag after name).rar Thanks, that did it Looks realy good.
.TuG.brok21k Posted June 13, 2007 Report Posted June 13, 2007 Please note: The uploading of XML is currently upto you. We are currently testing the file uploading methods, please make sure you back up you XML before use. And make sure you don't upload previously uploaded files in this current version (1.00)
.TuG.Beaver Posted June 13, 2007 Report Posted June 13, 2007 Current known bugs fixed and incorporated into v1.01 Release.
Recommended Posts