TGPSP - v1.00 - Bugs Discussion

[ROCO*AFZ*]

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]

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]

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*]

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]

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]

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]

Ok, just try using vU (with out .) for now.

 

and reduce $tablesize to 50 or 60 in config.php

 

$tablesize = '60%';

[.TuG.brok21k]

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]

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]

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]

Current known bugs fixed and incorporated into v1.01 Release.