Error in mysql DB creation in wamp
Posted by: girish (194.165.146.---)
Date: January 23, 2016 11:24AM

After successful wamp server installation when i try to create the mysql database it shows duplicate column name errors

Failed. Details:

SQL Statement:

Error Code:

1060

Error Text:

Duplicate column name "admin_group_id"
Executing: ../../database_schema/upgrades/2.3/data.sql

can you please help in this regard?

Options: ReplyQuote
Re: Error in mysql DB creation in wamp
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: January 23, 2016 12:27PM

Hi

Can you answer these questions please Read before you ask a question

Thankyou

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Error in mysql DB creation in wamp
Posted by: girish (194.165.146.---)
Date: January 23, 2016 01:22PM

1 - Windows version used - windows server 2012 R2 64 bit
2 - Version WampServer -wamp server 2.5 64 bit
3 - Apache Version -2.4.9
4 - PHP Version - 5.5.12
5 - MySQL Version-5.6.17
6 - What color is the WampServer icon (in the notification area of the taskbar) - Green
7.
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
127.0.0.1 localhost
8. Yes
9.Yes
10.Mentioned(Duplicate column name )
11.Firewall not set
12. c:\wamp

Options: ReplyQuote
Re: Error in mysql DB creation in wamp
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: January 23, 2016 01:29PM

So what is this `database_schema/upgrades/2.3/data.sql` supposed to be doing, and where did you get it from?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Error in mysql DB creation in wamp
Posted by: girish (194.165.146.---)
Date: January 23, 2016 01:38PM

while i install mysql database in wampserver
i.e
localhost\booked\web\install
in the 1st page it asks for installation password
2nd page it asks for database username & password
I checked create database booked & create sample data
after that i'm getting this error

Options: ReplyQuote
Re: Error in mysql DB creation in wamp
Posted by: girish (194.165.146.---)
Date: January 23, 2016 01:53PM

You can view the screenshot image in this forum
[php.brickhost.com]

Options: ReplyQuote
Re: Error in mysql DB creation in wamp
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: January 23, 2016 02:22PM

This is an Application issue.

There is nothing about this problem that is directly related to WAMPServer.

If you application fails you, contact the people that wrote your applicatin

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Error in mysql DB creation in wamp
Posted by: girish (194.165.146.---)
Date: January 23, 2016 02:25PM

Ok. Thanks RiggsFolly

Options: ReplyQuote


Sorry, only registered users may post in this forum.