| View previous topic :: View next topic |
| Author |
Message |
Katarn
Joined: 13 May 2004
Posts: 2
|
| Posted: Thu May 13, 2004 1:09 pm Post subject: Problems with creating a table |
|
|
Hi,
I've downloaded phpsitestats today, and I've created a database. I've filled in the information on the configpage. When I try to create a table on the setuppage, I get the following error:
Code: Failed to create table
Debug info: CREATE TABLE ( Date varchar(8) NOT NULL default '', Ip varchar(28) NOT NULL default '', Referrer varchar(200) NOT NULL default '', Agent varchar(100) NOT NULL default '', ) TYPE=MyISAM
I hope someone can help me with this. |
|
| Back to top |
|
Vlad Alexa Mancini
Joined: 07 Jul 2003
Posts: 303
|
| Posted: Thu May 13, 2004 1:46 pm Post subject: |
|
|
| maybe the user you entered in the database config does not have permissions to create tables |
|
| Back to top |
|
Katarn
Joined: 13 May 2004
Posts: 2
|
| Posted: Thu May 13, 2004 1:49 pm Post subject: |
|
|
mancini wrote: maybe the user you entered in the database config does not have permissions to create tables
That can't be it, I'm using this on a localhost, so I have al the permissions needed. |
|
| Back to top |
|
canabary
Joined: 10 May 2004
Posts: 1
|
| Posted: Thu May 13, 2004 3:40 pm Post subject: |
|
|
um I think he means more like :
root
the pass
or like me:
Canabary (my mysql database name)
the pass (that I made with the apache2triad pass changer.) |
|
| Back to top |
|
Vlad Alexa Mancini
Joined: 07 Jul 2003
Posts: 303
|
| Posted: Fri May 14, 2004 12:08 pm Post subject: |
|
|
maybe you have register_globals off in the php configuration
phpsitestats does not work in such conditions yet |
|
| Back to top |
|
ed
Joined: 15 Jun 2004
Posts: 2
|
| Posted: Tue Jun 15, 2004 6:59 pm Post subject: table problems |
|
|
Failed to create table
Debug info: CREATE TABLE ( Date varchar(8) NOT NULL default '', Ip varchar(28) NOT NULL default '', Referrer varchar(200) NOT NULL default '', Agent varchar(100) NOT NULL default '', ) TYPE=MyISAM
remove the , on the last default '' |
|
| Back to top |
|
Vlad Alexa Mancini
Joined: 07 Jul 2003
Posts: 303
|
| Posted: Tue Aug 03, 2004 4:45 pm Post subject: |
|
|
| yea i just noticed that bug while making the new version too , have no ideea how it passed thru the prerelease testing |
|
| Back to top |
|
Raptor
Joined: 23 Dec 2005
Posts: 2
|
| Posted: Sat Dec 24, 2005 6:20 am Post subject: Register globals off |
|
|
It is much better for security to have Register globals off.
Can phpsitestats be fixed to work with this setting?
Thanks! |
|
| Back to top |
|
| |
