Hi, I installed 2.0.2 by replacing the files with 1.6 (1.0.5) My Alerts since I couldn't uninstall 1.6 Alerts manually. I noticed that the templates did not update to 2.0.2, my theme was still using 1.6 templates. So I uninstalled 2.0.2 Alerts and tried to install it again and I get this internal error:
SQL error:
1054 - Unknown column 'can_be_user_disabled' in 'field list'
Query:
INSERT INTO mybb_alert_types (`id`,`code`,`enabled`,`can_be_user_disabled`) VALUES (0,'rep',1,1), (0,'pm',1,1), (0,'buddylist',1,1), (0,'quoted',1,1), (0,'post_threadauthor',1,1), (0,'subscribed_thread',1,1)
![[Image: 8z10NPd.png]](https://camo.mybb.com/585397a49fa876f3bb487f152852a3963aea8b30/687474703a2f2f692e696d6775722e636f6d2f387a31304e50642e706e67)
Can you look into this please?
Thank you.
It looks like your database has gotten pretty screwed up due to how you did things. You'll need to add the "can_be_user_disabled" column to my_alert_types from phpMyAdmin:
ALTER TABLE mybb_alert_types ADD `can_be_user_disabled` TINYINT(4) NOT NULL DEFAULT '1'
(2015-09-18, 07:43 PM)Euan T Wrote: [ -> ]It looks like your database has gotten pretty screwed up due to how you did things. You'll need to add the "can_be_user_disabled" column to my_alert_types from phpMyAdmin:
ALTER TABLE mybb_alert_types ADD `can_be_user_disabled` TINYINT(4) NOT NULL DEFAULT '1',
I tried but I get an error when trying to create the column.
Thank you.
Jajaja, you make my day.
mikeh you hav to enter inside SQL and run that query into that option or inside console you can use a more difficult commands in command prompt.
Or make a value like you wanna do adding values but the values are matched one by one, in every column, only add new field with name can_be_user_disabled, and select type to TINYINT and set 4 and on VALUE set NOT NULL and value on textbox is 1.
I recomend you to go to SQL section directly and write the etire sentence and the click on RUN and that´s all.
What?
I don't know phpmyadmin well.
Thank you.
(2015-09-18, 08:18 PM)mikeh Wrote: [ -> ] (2015-09-18, 07:43 PM)Euan T Wrote: [ -> ]It looks like your database has gotten pretty screwed up due to how you did things. You'll need to add the "can_be_user_disabled" column to my_alert_types from phpMyAdmin:
ALTER TABLE mybb_alert_types ADD `can_be_user_disabled` TINYINT(4) NOT NULL DEFAULT '1',
I tried but I get an error when trying to create the column.
http://i.imgur.com/gTqUkyP.png
http://i.imgur.com/GgOMdOq.png
Thank you.
Open phpMyAdmin, select the table, press the "SQL" tab, enter the code I posted, press run. You're using the GUI to add the column, which would also work but the code I provided does it for you.
(2015-09-18, 09:58 PM)Euan T Wrote: [ -> ] (2015-09-18, 08:18 PM)mikeh Wrote: [ -> ] (2015-09-18, 07:43 PM)Euan T Wrote: [ -> ]It looks like your database has gotten pretty screwed up due to how you did things. You'll need to add the "can_be_user_disabled" column to my_alert_types from phpMyAdmin:
ALTER TABLE mybb_alert_types ADD `can_be_user_disabled` TINYINT(4) NOT NULL DEFAULT '1',
I tried but I get an error when trying to create the column.
http://i.imgur.com/gTqUkyP.png
http://i.imgur.com/GgOMdOq.png
Thank you.
Open phpMyAdmin, select the table, press the "SQL" tab, enter the code I posted, press run. You're using the GUI to add the column, which would also work but the code I provided does it for you.
I tried that.
Am I doing something wrong?
Try removing the comma at the end, that was a mistake from copy pasting.