You are an unregistered user, you can register here
Navigation

Information

Site

Donations
If you wish to make a donation you can by clicking the image below.


 
Go Back   The Unreal Admins Page > Forums > Hosted Forums > UTStats > General Chat

Reply
Thread Tools Display Modes
  #1  
Unread 14th December, 2013, 03:03 PM
ALLSTARR ALLSTARR is offline
Rampage
 
Join Date: May 2008
Posts: 63
Default SQL utstats

trying to drop the tables but get this message ^^
Whats causing this or how can i solve this ^^

Fout

SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 09, 2005 at 12:25 AM
-- Server version: 4.0.22
-- PHP Version: 4.3.9
--
-- Database: `utstats`
--
-- --------------------------------------------------------
--
-- Table structure for table `uts_games`
--
CREATE TABLE `uts_games` (

`id` tinyint( 3 ) unsigned NOT NULL AUTO_INCREMENT ,
`gamename` varchar( 100 ) NOT NULL default '',
`name` varchar( 100 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) TYPE = MYISAM AUTO_INCREMENT =9;



MySQL meldt: Documentatie
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=9' at line 24
Reply With Quote
  #2  
Unread 15th December, 2013, 01:51 AM
{SoP}axewound {SoP}axewound is offline
Killing Spree
 
Join Date: Aug 2006
Posts: 27
Default

Change type= to engine= in the SQL create statement.
Reply With Quote
  #3  
Unread 16th December, 2013, 08:06 PM
ALLSTARR ALLSTARR is offline
Rampage
 
Join Date: May 2008
Posts: 63
Default

oki thx !! That worked^^
But...i dunno for what reason...my second statspage just doesnt import logs ....
im using utstatstriggerx4 wich points to my both webservers.
The first webserver is using cronjob to import the logs.This is set to every minute.So is it possible that the logs arent ava anymore cos of the 1 minute?i mean for webserver 2(where importing not works)
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:21 AM.


 

All pages are copyright The Unreal Admins Page.
You may not copy any pages without our express permission.