Author Topic: Database Error (Read 11798 times)

mj38 · « **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.

JimM · « **Reply #1 on:** January 13, 2009, 11:23:58 PM »

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:

Code: [Select]

UPDATE `smf_settings` SET `value` = '1.1.7' WHERE `variable` = 'smfVersion' LIMIT 1
Replace 'smf_' with your prefix if it is different.

mj38 · « **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

JimM · « **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.

Ricky. · « **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.

JimM · « **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.

ysNoi · « **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..!

JimM · « **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.

ysNoi · « **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..!

JimM · « **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?

mj38 · « **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

JimM · « **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

ysNoi · « **Reply #12 on:** January 20, 2009, 12:44:07 AM »

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

JimM · « **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.

bindasboy · « **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

bindasboy · « **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..........

JBlaze · « **Reply #16 on:** April 24, 2009, 05:39:07 AM »

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

BigMike · « **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).

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 · « **Reply #18 on:** April 17, 2012, 11:21:30 AM »

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 · « **Reply #19 on:** April 17, 2012, 11:24:41 AM »

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

News:

Author Topic: Database Error (Read 11798 times)