Board index   FAQ   Search  
Register  Login
Board index PHP PHP Scripts

my sql error

Links for php scripts

Moderators: macek, egami, gesf

my sql error

Postby florin112 » Wed Aug 01, 2012 4:28 am

Hi!

I want to make a tracker. I am searching for a script and i find a good php script. When i test it in xampp, an error occured. First photo is when i created the database called "database", and the second when error appear.Thanks in advanced.
Attachments
error.jpg
error.jpg (87.49 KiB) Viewed 385 times
databse.jpg
databse.jpg (76.81 KiB) Viewed 385 times
florin112
New php-forum User
New php-forum User
 
Posts: 2
Joined: Wed Aug 01, 2012 4:20 am

Re: my sql error

Postby freshnet » Wed Aug 01, 2012 5:19 am

from the screenshots, xampp is expecting your database to be called 'database' but it's called 'bazadate'. You'll likely need to edit your mysql/phpmyadmin ini files to change this. Look at the xampp documentation to find out more.
User avatar
freshnet
php-forum Active User
php-forum Active User
 
Posts: 252
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

Re: my sql error

Postby florin112 » Wed Aug 01, 2012 7:23 am

Ok.I changed the name of database.Sane problem.Another script look like this:
Attachments
Untitled.jpg
Untitled.jpg (87.59 KiB) Viewed 379 times
florin112
New php-forum User
New php-forum User
 
Posts: 2
Joined: Wed Aug 01, 2012 4:20 am

Re: my sql error

Postby freshnet » Thu Aug 02, 2012 3:19 pm

try using ENGINE=MyISAM instead of TYPE=MyISAM
User avatar
freshnet
php-forum Active User
php-forum Active User
 
Posts: 252
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

Re: my sql error

Postby freshnet » Thu Aug 02, 2012 3:21 pm

you may actually need ENGINE=MyISAM DEFAULT CHARSET=utf8
User avatar
freshnet
php-forum Active User
php-forum Active User
 
Posts: 252
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

Re: my sql error

Postby Antrikssh » Mon Aug 06, 2012 5:45 am

Its a syntax problem that occured in your querry.

Please make change in line 'comment' varchar(255) not null default" in your querry in place of that write 'comment' varchar(255) not null default with out ("). It will may help you.

Regards,
Antrikssh.... :)
Antrikssh
New php-forum User
New php-forum User
 
Posts: 22
Joined: Wed May 02, 2012 5:27 am


Return to PHP Scripts

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron