Optimus_Sam Posted January 21, 2014 Share Posted January 21, 2014 (edited) Hi everyone, I have this error when i click on my modules tab in BO: ALTER TABLE `ps_advice` ADD `start_date` INT NULL DEFAULT 0 , ADD `stop_date` INT NULL DEFAULT 0 Here's a screenshot: The thing is that i've tried adding start_date and stop_date but hasn't worked. Don't know why yet This is how PHPmyAdmin looks like: Anyone have an idea? Don't know what i have to do regarding the duplicate column thing and 'alter table'... Kind regards, Sam Edited January 22, 2014 by Optimus_Sam (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 21, 2014 Share Posted January 21, 2014 so strange bug. can you now remove these two tables? i mean start_date i stop_date something doesn't work with this, definitely. Link to comment Share on other sites More sharing options...
Optimus_Sam Posted January 21, 2014 Author Share Posted January 21, 2014 (edited) HI Vekia, Yes idd very strange. I deleted the start_date and stop_date. Which gave me this error: But i can't add another "hide" because there is already one in it... and after doing another refresh it gave me this: Edited January 21, 2014 by Optimus_Sam (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 21, 2014 Share Posted January 21, 2014 ok, so can you remove also hide column? i run some module updates before this message started to appear? Link to comment Share on other sites More sharing options...
Optimus_Sam Posted January 22, 2014 Author Share Posted January 22, 2014 Oh yes i rememeber. I tried to update Google sitemap module (i think, not sure). when this started to happen. I'll try and remove the hide column as you instructed. Keep you posted friend. Sam Link to comment Share on other sites More sharing options...
Optimus_Sam Posted January 22, 2014 Author Share Posted January 22, 2014 Completely messed it up . Vekia, can you take a look in my phpMyAdmin? I'll PM you the login data if you want.. I really can't seem to figure this out Link to comment Share on other sites More sharing options...
vekia Posted January 22, 2014 Share Posted January 22, 2014 sure, can i get also access to BO?, if it is possible 1 Link to comment Share on other sites More sharing options...
Optimus_Sam Posted January 22, 2014 Author Share Posted January 22, 2014 oh thank god Ok, i'll pm you in a minute with the login information Link to comment Share on other sites More sharing options...
vekia Posted January 22, 2014 Share Posted January 22, 2014 fixed it was problem with gamification module (something weird with update) 1 Link to comment Share on other sites More sharing options...
Optimus_Sam Posted January 22, 2014 Author Share Posted January 22, 2014 fixed it was problem with gamification module (something weird with update) Link to comment Share on other sites More sharing options...
omaral Posted January 25, 2014 Share Posted January 25, 2014 Can you share with us how to solve this issue? Link to comment Share on other sites More sharing options...
vekia Posted January 26, 2014 Share Posted January 26, 2014 i added these fields manually to database (as i wrote above) Link to comment Share on other sites More sharing options...
omaral Posted January 27, 2014 Share Posted January 27, 2014 My problem was bit different because I had all columns in DB but the query was asking for 'start_day' and my column name was 'start_date' so I just had to change the column name. Link to comment Share on other sites More sharing options...
vekia Posted January 27, 2014 Share Posted January 27, 2014 you had to add start_day instead of changing name of existing columns, it's because of retrocompability (i suppose so) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now