SOLVED Problems With Tables


Subject: Problems With Tables
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?

Profile PM  
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):
Code: [Download] [Hide] [Select]
ALTER TABLE `ip_users` ADD COLUMN `user_allow_mass_email` TINYINT(1) DEFAULT '1' NOT NULL AFTER `user_allow_pm_in`


Greets!

Subject: Re: Problems With Tables
i have user_allow_pm but missing user_allow_pm_in

Profile PM  
Subject: Re: Problems With Tables
KasLimon wrote: [View Post]
Try to run the updater again... It should fix it...
Have you tried?

Greets!

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

Profile PM  
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).

Spoiler: [ Show ]


Greets ;)

Subject:
SOLVED !!!!

Just pm_in was missing.




Thanks.

Profile PM  

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.655s (PHP: 5% SQL: 95%)
SQL queries: 10 - Debug Off - GZIP Enabled