Database creation problem

[jmm]

Can somebody tell me why I keep getting an error everytime I try to create a database using PHPMyAdmin:

Here is the error:
"Error MySQL said: 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 '' at line 1
Back (javascript:history.go(-1)) "

Thanks for support
Jmm.

[eva2000]

Please enter your vBulletin.com forum username on the form on this page to receive support for this issue: http://www.vbulletin.com/members/forums.php
- you will need your vB license customer number and password to access this form.

[jmm]

Please enter your vBulletin.com forum username on the form on this page to receive support for this issue: http://www.vbulletin.com/members/forums.php
- you will need your vB license customer number and password to access this form.

Hi Eva,
Thanks for the reply.
Just entered my vB license customer number and password succesfully.

phpmyAdmin problems:
Currently running (testing) apache on winXP, and did install vb 2.3 without a problem. But, I need to play around with mysql databases using phpmyadmin.
As a note: phpmyadmin config_inc.php file has not been altered or tempered with.

On startup (http://localhost/phpmyadmin/index.php), I get a screen, type in a database name (eg. something) into the box and hit the "create" button. All I get is an error like this: "Error MySQL said: 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 '' at line 1
Back (http://java%20script:history.go(-1)/) "

Secondly, everytime I try to run an sql query on a selected database like the 'test' database that comes preinstalled with phpmyadmin, I get a 'query succesfully run on database' message. But the database (test) directory remains empty. Can you enlighten me on this?

Thirdly, whenever I select a database like vbulletin with phpmyadmin, I always get this warning message: 'no tables found in database'. Is this usual?

I intend to eventually run apache on redhat linux, but first, I would need to solve this basic mysql/phpmyadmin problems. Any assistance on this issues would be highly appreciated.

Thanks for help.
Jmm

[Cary]

You're still showing up as unlicensed. Make sure you add the email address that you used to register on these forums to that list. I heard once that it's case sensitive.

[jmm]

You're still showing up as unlicensed. Make sure you add the email address that you used to register on these forums to that list. I heard once that it's case sensitive.

Hi Caryk,

I just registered my vb username and password again, plus my old email address. If I still show up as unlicensed, then I wouldn't mind sending you a pm of my username and password.

Thanks
Jmm

[Steve Machol]

You're still not showing up as licensed. Fill out a support ticket at:

http://www.vbulletin.com/members/support_form.php

[jmm]

You're still not showing up as licensed. Fill out a support ticket at:

http://www.vbulletin.com/members/support_form.php

Hi Steve,

Support ticket has just been filled out. Please, take a look at it.
Thanks
Jmm

[Steve Machol]

I did and you did not enter the email address you used to register on these forums. That's the one you need to enter here:

http://www.vbulletin.com/members/forums.php

[jmm]

I did and you did not enter the email address you used to register on these forums. That's the one you need to enter here:

http://www.vbulletin.com/members/forums.php

Alright Steve,

Just submitted my vb username, password and another old email again. I hope this puts to rest this issue.

But, shouldn't somebody with a legal copy of vb, a username and a password that grant access to the member area, show up as licensed member even with a new email?

Thanks for your continued support.
Please, don't forget to assist me with my pending mysql/phpmyadmin problems.
Jmm

[Steve Machol]

Sorry I checked again and you did not add the email address you used to register on these forums. I have manually made this change for you.

[Steve Machol]

P.S. I have the same problem creating a database with phpMyAdmin. It doesn't work for me either.

[jmm]

P.S. I have the same problem creating a database with phpMyAdmin. It doesn't work for me either.

Hi Steve,

Thanks for manually making those changes for me.
The problems with phpmyadmin are really annoying. I hope somebody can assist with this.

Jmm

[Steve Machol]

Why don't you just login to the server and mysql and create the database directly:

http://www.mysql.com/doc/en/CREATE_DATABASE.html

[jmm]

Why don't you just login to the server and mysql and create the database directly:

http://www.mysql.com/doc/en/CREATE_DATABASE.html

Hi Steve,

Apache and mysql servers are always running on my winxp machine. I tried creating the database in dos by changing to mysql/bin directory and typing in the followin command:

CREATE DATABASE [IF NOT EXISTS] db_name

No success, unfortunately. Am I missing or doing something wrong?
I also have winmysqladmin, but have no idea how to create a database or run sql queries with it.

May be you can fill me in.
Thanks
Jmm

[jmm]

Hi Steve,

Apache and mysql servers are always running on my winxp machine. I tried creating the database in dos by changing to mysql/bin directory and typing in the followin command:

CREATE DATABASE [IF NOT EXISTS] db_name

No success, unfortunately. Am I missing or doing something wrong?
I also have winmysqladmin, but have no idea how to create a database or run sql queries with it.

May be you can fill me in.
Thanks
Jmm

It's all good Steve,

I just figured out how to create a database in dos.
Now I have to figure out how to run queries.

Later
Jmm

[Steve Machol]

You can run queries either by logging into mysql:

mysql -uUSERNAME -p DBNAME

..or in the SQL tab in phpMyAdmin.

[jmm]

You can run queries either by logging into mysql:

mysql -uUSERNAME -p DBNAME

..or in the SQL tab in phpMyAdmin.

phpMyAdmin has not worked for me so far. Ran sql queries by browsing to text files and clicking the "Go" button. Response message: "Your SQL query has been executed succesfully". Well, I check the database, and absolutely nothing has changed.

I wonder if anybody else has these same problems with phpMyAdmin on winXP.

Jmm