Advertisement:

Author Topic: The database value you're trying to insert does not exist: personal_text  (Read 6107 times)

Offline kamkar

  • Semi-Newbie
  • *
  • Posts: 11
I have recently upgraded my forum from 1.11 to 2.0 RC2.

Now while users are registering they are getting following error.

"The database value you're trying to insert does not exist: personal_text"

I am using following mods

Global Header Footer
Ad Management
Copy Topics
Sitemap

Please help.

Offline Joey Smith™

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,356
  • Gender: Male
Re: The database value you're trying to insert does not exist: personal_text
« Reply #1 on: February 02, 2010, 09:11:35 PM »
It appears this column is missing from the database. Can you please verify it is in the members table via phpmyadmin?

Offline kamkar

  • Semi-Newbie
  • *
  • Posts: 11
Re: The database value you're trying to insert does not exist: personal_text
« Reply #2 on: February 02, 2010, 10:29:34 PM »
I have already checked the same. The table smf_members contains column personal_text. This is varchar(255) but still the problem is there.

In the meantime I have disabled alll the mods. Uploaded all the upgrade files again. Ran upgrade.php once again and got no error.

I also tried to run repair settings and found no error there.
 
BUT the problem persists. Pls help.


It appears this column is missing from the database. Can you please verify it is in the members table via phpmyadmin?

Offline kamkar

  • Semi-Newbie
  • *
  • Posts: 11
Re: The database value you're trying to insert does not exist: personal_text
« Reply #3 on: February 08, 2010, 02:01:16 AM »
I got no response from this forum BUT i could solve the problem on my own.

In table smf_settings the variable 'default_personal_text' was not there. I dont know from where this field needs to be inserted. So I have manually added this variable in smf_settings and problem got solved. 

Offline InfoStrides

  • Full Member
  • ***
  • Posts: 497
  • www.TheInfoStrides.com
    • InfoStrides on Facebook
    • @TheInfoStrides on Twitter
    • TheInfoStrides.com
Re: The database value you're trying to insert does not exist: personal_text
« Reply #4 on: February 20, 2010, 05:40:14 PM »

I got no response from this forum BUT i could solve the problem on my own.

In table smf_settings the variable 'default_personal_text' was not there. I dont know from where this field needs to be inserted. So I have manually added this variable in smf_settings and problem got solved. 

Please how did you resolve this because I am having similar error. You guidance would be appreciated.

Thank you.

Offline InfoStrides

  • Full Member
  • ***
  • Posts: 497
  • www.TheInfoStrides.com
    • InfoStrides on Facebook
    • @TheInfoStrides on Twitter
    • TheInfoStrides.com
Re: The database value you're trying to insert does not exist: personal_text
« Reply #5 on: February 20, 2010, 06:09:12 PM »
 
I got it resolved! I inserted  a new row "default_personal_text" in smf_settings.

Thanks.

Offline petesky

  • Jr. Member
  • **
  • Posts: 312
Re: The database value you're trying to insert does not exist: personal_text
« Reply #6 on: February 25, 2010, 07:50:53 AM »
Hi !

Can someone please tell me whats wrong in mine ?

The database value you're trying to insert does not exist: id_board

Offline InfoStrides

  • Full Member
  • ***
  • Posts: 497
  • www.TheInfoStrides.com
    • InfoStrides on Facebook
    • @TheInfoStrides on Twitter
    • TheInfoStrides.com
Re: The database value you're trying to insert does not exist: personal_text
« Reply #7 on: February 27, 2010, 05:44:26 PM »
Hi !

Can someone please tell me whats wrong in mine ?

The database value you're trying to insert does not exist: id_board

Check it if not exist. You need to create it manually in your MyPHPadmin. This error is likely due to database migration.

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,818
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: The database value you're trying to insert does not exist: personal_text
« Reply #8 on: February 27, 2010, 06:25:38 PM »
What are your users doing when they're getting this error? It means that there's a problem with a query somewhere. Without a file and line or at least an idea of what they're doing when they're getting that error, it's hard to provide a fix.
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org