News:

Wondering if this will always be free?  See why free is better.

Main Menu

Database Error

Started by mj38, January 13, 2009, 11:01:18 PM

Previous topic - Next topic

mj38

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.

JimM

Quote from: mj38 on January 13, 2009, 11:01:18 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

Quote from: mj38 on January 13, 2009, 11:01:18 PM
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:

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

mj38

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

JimM

#3
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.
Jim "JimM" Moore
Former Support Specialist

Ricky.

For related mod settings, there is option to build index for related topics. Do that and it will create tables for you.

JimM

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:
QuoteSMF-1.1/related_topics.php
This file should be able to execute standalone.
Jim "JimM" Moore
Former Support Specialist

ysNoi

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."

JimM

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

ysNoi

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."

JimM

@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

mj38

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

JimM

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

ysNoi

#12
Quote from: JimM on January 18, 2009, 11:30:11 PM
@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..!

"Don't fix it if it ain't broken, don't break it if you can't fix it."

JimM

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

bindasboy

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

bindasboy

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..........

JBlaze

Quote from: bindasboy 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..........

Marking as solved :)
Jason Clemons
Former Team Member 2009 - 2012

BigMike

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

Quote from: bindasboy 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..........

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

BigMike

Ahhhhhhhhhhhhhhh sorry I did not see this post!

Quote from: bindasboy on April 24, 2009, 12:21:34 AM
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

BigMike

Quote from: bindasboy on April 24, 2009, 12:21:34 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

Advertisement: