WampServer

Windows Vista SP1

I had a fresh install of WampServer that worked fine.

I then installed the MySQL 5.0.51b addon and now phpMyAdmin fails with the following error:

Error

SQL query:

SHOW PLUGINS

MySQL said:
#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 'PLUGINS' at line 1

SHOW PLUGIN was only added in 5.1.5 and then changed to SHOW PLUGINS in 5.1.9 so this why it wont work in 5.0.x

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
Build Great Websites Quickly-[pampserver.com]



Edited 1 time(s). Last edit at 01/03/2009 08:02PM by stevenmartin99.

Thanks for the info Steven,

The phpMyAdmin website states it supports mysql 5.0.15 and newer - is this error specific to the phpMyAdmin distributed with WampServer?

it depedends when you download wamp., the version available with wamp now is 5.13 so it will work fine with this. why did you change the version of mysql?

you need to look at the mysql website and not the phpmyadmin site>>[dev.mysql.com]

just switch it back to 5.1.3??

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
Build Great Websites Quickly-[pampserver.com]



Edited 1 time(s). Last edit at 01/04/2009 04:57PM by stevenmartin99.

I didn't change the version of phpmyadmin - the only thing i changed was the version of mysql, which I downloaded from the add-ons section of the WampServer website.

Other than that one change it is a completely stock install - I haven't made any changes to any configuration files yet.

The reason I want to use MySQL 5.0.51 is because my production server is still on MySQL 5.0.x.

i didnt say phpmyadmin


Im talking about Mysql

Ill Say Again

SHOW PLUGIN was only added in MYSQL 5.1.5 and then changed to SHOW PLUGINS in MYSQL 5.1.9 so this why it wont work in MYSQL 5.0.x


if your production sever runs SHOW PLUGINS then it is not using MYSQL 5.0.x

To Fix this error switch back to MYSQL 5.1.3 Supplied with wamp or sont use SHOW PLUGIN(s)



IF ( The phpMyAdmin website states it supports mysql 5.0.15 and newer ) THEN IT IS INCORRECT,

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
Build Great Websites Quickly-[pampserver.com]

Sorry - I misread your previous post.

My apologies - this problem appears to have been a browser caching problem - I tested phpmyadmin with mysql 5.1.x before switching to mysql 5.0.x

I tried a different browser and phpmyadmin worked fine so that led me to suspect the browser cache/cookies - I cleared Firefox's cache multiple times while trying to solve this problem, but for some reason that didn't work. I had to manually delete the localhost cache/cookies and then phpmyadmin started working again.

phpmyadmin works fine using mysql 5.0.51.b

how do i disable SHOW PLUGIN(s) ?

I delete my cache for the browser, and then restarted my browser...ie at the time, this fixed the problem, thanks bas10, good advice....

@saki :
You don't need to disable SHOW PLUGIN.
This appears because PhpMyAdmin version doesn't fit your Mysql server version.
Download a previous PhpMyAdmin version, put it in wamp/apps folder and modify wamp/alias/phpmyadmin.conf file

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com