Jump to content
The Unknown Ghosts

TGPSP - v1.00 - Bugs Discussion


Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

×
×
  • Create New...