I have recently upgraded from a previous version of icyphonix
I have problems to change user profile
SQL Error : 1054 Unknown column 'user_allow_mass_email' in 'field list'
I dont have user_allow_mass_email
How i can insert that line on pre-existent user database?
Icy Phoenix
Old Support Topics - Problems With Tables
roco [ Wed 16 Apr, 2008 22:07 ]
Post subject: Problems With Tables
Post subject: Problems With Tables
KasLimon [ Wed 16 Apr, 2008 22:21 ]
Post subject: Re: Problems With Tables
Post subject: Re: Problems With Tables
Try to run the updater again... It should fix it...
If not, run this sql (replacing ip_ with your table prefix):
Greets!
If not, run this sql (replacing ip_ with your table prefix):
ALTER TABLE `ip_users` ADD COLUMN `user_allow_mass_email` TINYINT(1) DEFAULT '1' NOT NULL AFTER `user_allow_pm_in`
Greets!
roco [ Wed 16 Apr, 2008 22:35 ]
Post subject: Re: Problems With Tables
Post subject: Re: Problems With Tables
i have user_allow_pm but missing user_allow_pm_in
KasLimon [ Wed 16 Apr, 2008 22:37 ]
Post subject: Re: Problems With Tables
Post subject: Re: Problems With Tables
roco [ Wed 16 Apr, 2008 22:57 ]
Post subject:
Post subject:
Tengo instalado el phoenix desde hace mas de un año, pero al cambiar de hosts han surgido estos problemas, porque he instalado el phoenix que tenia pero con las tablas antiguas de un par de versiones anteriores, no se donde encontrar el updater, me da la sensacion que son muy pocas las tablas que por algun motivo no estan por eso queria un dump de las estructuras de ip_users para ver cuales me faltan. He recuperado todos los posts y los foros. Escribo en espà ñol para agilizar esto y porque veo que eres español, ahora la linea en ingles.
I need a blank dump of ip_users structure.
Thanks a lot KasLimon
I need a blank dump of ip_users structure.
Thanks a lot KasLimon
KasLimon [ Wed 16 Apr, 2008 23:36 ]
Post subject: Re: Problems With Tables
Post subject: Re: Problems With Tables
To find the updater just download last Icy Phoenis package and upload the file install/update_to_ip.php to your forum root.
Then, run it (enter to www.yourforum.com/update_to_ip.php).
Select the most appropriate option and wait until it finishes. Then you'll see it repaired (I hope).
Greets
Then, run it (enter to www.yourforum.com/update_to_ip.php).
Select the most appropriate option and wait until it finishes. Then you'll see it repaired (I hope).
Spoiler: [ Show ]
Greets
roco [ Thu 17 Apr, 2008 22:37 ]
Post subject:
Post subject:
SOLVED !!!!
Just pm_in was missing.
Thanks.
Just pm_in was missing.
Thanks.