my sql error

Links for php scripts

Moderators: macek, egami, gesf

florin112
New php-forum User
New php-forum User
Posts: 2
Joined: Wed Aug 01, 2012 4:20 am

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 560 times
databse.jpg
databse.jpg (76.81 KiB) Viewed 560 times

User avatar
freshnet
php-forum Active User
php-forum Active User
Posts: 285
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

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.

florin112
New php-forum User
New php-forum User
Posts: 2
Joined: Wed Aug 01, 2012 4:20 am

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 554 times

User avatar
freshnet
php-forum Active User
php-forum Active User
Posts: 285
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

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: 285
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

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

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


Return to “PHP Scripts”

Who is online

Users browsing this forum: No registered users and 1 guest

cron