Advertisement:
GCWebhosting

Author Topic: Database Error  (Read 29954 times)

Offline mj38

  • Newbie
  • *
  • Posts: 9
Database Error
« on: January 13, 2009, 11:01:18 PM »
i was not for sure were to put this post here i hope it is in the right forum. i need some help i got this after i made a  post in my forum. how do i go about fixing this error

Database Error
Table 'oddlyeno_smf4.smf_related_subjects' doesn't exist
File: /home/oddlyeno/public_html/Sources/Subs-RelatedFulltext.php
Line: 72

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.5. The above error might possibly go away if you execute the latest version of upgrade.php.

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Database Error
« Reply #1 on: January 13, 2009, 11:23:58 PM »
Database Error
Table 'oddlyeno_smf4.smf_related_subjects' doesn't exist
File: /home/oddlyeno/public_html/Sources/Subs-RelatedFulltext.php
Line: 72

This appears to be from Related Topics mod.  For mod Related Questions it is best to ask the mod author. You can find a link to a topic for the mod or a support board on the mod's page in the Mod Site


Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.5. The above error might possibly go away if you execute the latest version of upgrade.php.

This can be fixed by opening phpMyAdmin (What is phpMyAdmin?) and running the following query:

Code: [Select]
UPDATE `smf_settings` SET `value` = '1.1.7' WHERE `variable` = 'smfVersion' LIMIT 1
Replace 'smf_' with your prefix if it is different.
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline mj38

  • Newbie
  • *
  • Posts: 9
Re: Database Error
« Reply #2 on: January 15, 2009, 07:14:25 PM »
this error is showing up after i make a post and it will not show the post. but it will show the title of the post,and web hosting does not know how to fix this error. so i can get a update are what can i tell them how to fix this.
    Table 'oddlyeno_smf4.smf_related_subjects' doesn't exist
File: /home/oddlyeno/public_html/Sources/Subs-RelatedFulltext.php
Line: 72

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Database Error
« Reply #3 on: January 15, 2009, 07:49:51 PM »
That error is caused by the Related Topics mod.   Uninstall that mod and your error will go away.  Otherwise you will need to install the mod correctly.  It appears that you didn't create the table that it is looking for in the database.  Again all questions that you need to ask in the support topic for the mod.
« Last Edit: January 16, 2009, 09:10:45 AM by JimM »
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline Ricky.

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,057
    • Indian Linux Forums
Re: Database Error
« Reply #4 on: January 16, 2009, 02:05:11 AM »
For related mod settings, there is option to build index for related topics. Do that and it will create tables for you.

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Database Error
« Reply #5 on: January 16, 2009, 09:16:20 AM »
Normally there is a code segment included with the mod that you must either copy and paste into a SQL query or a file that will execute standalone that creates the database tables.

From the mod parser:
Quote
SMF-1.1/related_topics.php
This file should be able to execute standalone.
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline ysNoi

  • Jr. Member
  • **
  • Posts: 139
  • Gender: Male
  • I'm For DeMolay Alone
    • pHForums™
Re: Database Error
« Reply #6 on: January 18, 2009, 04:18:30 AM »
Hi..! Is this already solved..?

I got the same problem but it looks like this:

Database Error
Unknown column 'mem.skype' in 'field list'
File: /home/vol1/php0h.com/p0_2837090/htdocs/Sources/Load.php
Line: 890

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.

I got this error after installing the skype mod but I already uninstall it.
I got the same error after installation...!

How do I solve this one please help..!  :( :(
"Don't fix it if it ain't broken, don't break it if you can't fix it."

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Database Error
« Reply #7 on: January 18, 2009, 12:52:56 PM »
ysNoi - For mod Related Questions it is best to ask the mod author. You can find a link to a topic for the mod or a support board on the mod's page in the Mod Site
 
During the install/uninstall process did you get any errors?  It appears that it may not have uninstalled properly.  If that is the case you can use the mod parser on the Mod Site to display the edits required and remove them manually.
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline ysNoi

  • Jr. Member
  • **
  • Posts: 139
  • Gender: Male
  • I'm For DeMolay Alone
    • pHForums™
Re: Database Error
« Reply #8 on: January 18, 2009, 09:58:44 PM »
Thanks JimM for the reply..! Temporary, I got solved the problem by uploading a Load.php from my latest backup..!
"Don't fix it if it ain't broken, don't break it if you can't fix it."

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Database Error
« Reply #9 on: January 18, 2009, 11:30:11 PM »
@ysNoi - Glad to hear you got it sorted out.

@mj38 - Is this issue solved or do you still require assistance?
 
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline mj38

  • Newbie
  • *
  • Posts: 9
Re: Database Error
« Reply #10 on: January 19, 2009, 12:31:27 AM »
yes i just took the mod out my self and it has stop now. the olny error that i'm getting now is this one here. when you go to Forum Maintenance and try to fix the errors on the forum i will get this. but over all the forum is working good. the Package Installer would it be better that i just get web hosting to put the Packages in for me. are is there a update for that?

Duplicate entry '169-3' for key 3
File: /home/oddlyeno/public_html/Sources/RepairBoards.php
Line: 190

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Database Error
« Reply #11 on: January 19, 2009, 07:43:10 PM »
Have you checked your database in phpMyAdmin (What is phpMyAdmin?) to see if any tables are listed as needing repair.  If you search the forums here for 'duplicate key entry' you will see several topics related to your issue.

For the Package manager have you read this sticky?

SMF 1.1.7: Session verification failed error when installing mods
 
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline ysNoi

  • Jr. Member
  • **
  • Posts: 139
  • Gender: Male
  • I'm For DeMolay Alone
    • pHForums™
Re: Database Error
« Reply #12 on: January 20, 2009, 12:44:07 AM »
@ysNoi - Glad to hear you got it sorted out.

Thanks siR..! BTW, are my other errors related to this one..?

Here are my errors :

8: Undefined index: skype
File: /home/vol1/php0h.com/p0_2837090/htdocs/Themes/default/languages/TPShout.english.php (main sub template - eval?)
Line: 123

Database Error: Unknown column 'skype' in 'field list'
File: /home/vol1/php0h.com/p0_2837090/htdocs/Sources/Subs.php
Line: 631

8: Undefined index: skype
File: /home/vol1/php0h.com/p0_2837090/htdocs/Themes/default/languages/TPShout.english.php (summary sub template - eval?)
Line: 222

Database Error: Unknown column 'skype' in 'field list'
File: /home/vol1/php0h.com/p0_2837090/htdocs/Sources/Subs-Members.php
Line: 784

Thanks for the help..!

« Last Edit: January 20, 2009, 12:46:47 AM by ysNoi »
"Don't fix it if it ain't broken, don't break it if you can't fix it."

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Database Error
« Reply #13 on: January 20, 2009, 01:04:32 PM »
Nope, those appear to be related to a mod that would have something to do with skype.  Do you have a mod installed for that?  If so either it wasn't installed completely or uninstalled completely.
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline bindasboy

  • Newbie
  • *
  • Posts: 5
Re: Database Error
« Reply #14 on: April 24, 2009, 12:21:34 AM »
hello sir,

Plz help me to fix this error... i am getting the following error:

Table 'roshan_smf.smf_related_subjects' doesn't exist
File: /home/roshan/public_html/Sources/Subs-RelatedFulltext.php
Line: 86

I get the above error when ever i try to Remove, Move or Modify a Topic..
I am using SMF2.0 RC1. Help me..

Thanks

Offline bindasboy

  • Newbie
  • *
  • Posts: 5
Re: Database Error
« Reply #15 on: April 24, 2009, 01:11:36 AM »
My Problem has been solved.....

The table of Related Topic mod was not present on the database of my Forum... I Manually added that Table and now its working fine..........

Offline JBlaze

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,158
  • Gender: Male
    • @fragicide on Twitter
Re: Database Error
« Reply #16 on: April 24, 2009, 05:39:07 AM »
My Problem has been solved.....

The table of Related Topic mod was not present on the database of my Forum... I Manually added that Table and now its working fine..........

Marking as solved :)
Jason Clemons
Former Lead Customizer/Support Specialist
Twitter | Facebook | Instagram

Offline BigMike

  • Full Member
  • ***
  • Posts: 637
  • Gender: Male
    • http://facebook.com/huusoku on Facebook
    • Marlin Crawler, Inc.
Re: Database Error
« Reply #17 on: April 17, 2012, 11:14:21 AM »
I realize this topic is old but I need help from bindasboy. I encountered a lot of trouble getting the database file of Related Topics (related_topics.php) to install properly. I eventually got it to work and documented my efforts beginning at reply #630 here.

I just got it working yesterday and since have seen this same critical error, "Wrong value type sent to the database. Integer expected. (id_msg)" (for me being in my Display.php file at line 867).

My Problem has been solved.....

The table of Related Topic mod was not present on the database of my Forum... I Manually added that Table and now its working fine..........

bindasboy, could you please share the database query used to create the missing table? I don't have much info to go off of from this error so any help would be greatly appreciated. I am also going to link this to the mod's thread.

Thanks!
BigMike

Offline BigMike

  • Full Member
  • ***
  • Posts: 637
  • Gender: Male
    • http://facebook.com/huusoku on Facebook
    • Marlin Crawler, Inc.
Re: Database Error
« Reply #18 on: April 17, 2012, 11:21:30 AM »
Ahhhhhhhhhhhhhhh sorry I did not see this post!

Table 'roshan_smf.smf_related_subjects' doesn't exist
File: /home/roshan/public_html/Sources/Subs-RelatedFulltext.php
Line: 86

Ok I will look into figuring this out and will share the DB Query if I do-

Mike

Offline BigMike

  • Full Member
  • ***
  • Posts: 637
  • Gender: Male
    • http://facebook.com/huusoku on Facebook
    • Marlin Crawler, Inc.
Re: Database Error
« Reply #19 on: April 17, 2012, 11:24:41 AM »
Table 'roshan_smf.smf_related_subjects' doesn't exist

Ok, I already have this table installed so this isn't my issue. Here is the structure of my `related_subjects` table:

#    Column    Type    Collation       Attributes    Null    Default
1    id_topic    int(10)                      UNSIGNED    No    None
2    subject    tinytext    latin1_swedish_ci          No    None