Not registered yet?

doc1975 · #1 (**permalink**) SkyLight: Latestthreads Product 06-11-2009, 10:05 PM

After uploading the xml file and installing, i get the following database error, how to fix?:

PHP Code:

  Database error in vBulletin 3.8.2:

 
Invalid SQL:

 
    ## GET LATEST THREADS ##

    SELECT thread.*,threadid, title, dateline, views FROM acpthread ORDER BY views DESC LIMIT 5;

 
MySQL Error   : Unknown table 'thread'

Error Number  : 1051

Request Date  : Thursday, June 11th 2009 @ 03:02:28 PM

Error Date    : Thursday, June 11th 2009 @ 03:02:28 PM

Script        : http://www.anticouchpotato.com/forums/index.php

Referrer      : http://www.anticouchpotato.com/forums/video.php

IP Address    : 67.190.252.105

Username      : doc1975

Classname     : vB_Database

MySQL Version : 5.0.58

If I go back and disable it, the site functions as should...

AWMGolfer · #2 (**permalink**) Re: SkyLight: Latestthreads Product 06-12-2009, 07:55 PM

Same issue. I am using a different latest threads mod that works fine but I did have the same error showing.

doc1975 · #3 (**permalink**) Re: SkyLight: Latestthreads Product 06-13-2009, 05:23 PM

Bump! Still looking for an answer

doc1975 · #4 (**permalink**) Re: SkyLight: Latestthreads Product 06-15-2009, 06:34 PM

Somehow, i remember support being a bit more useful that it has in the last few days... still looking for a resolution to this issue.

Mmoore (Support) · #5 (**permalink**) Re: SkyLight: Latestthreads Product 06-17-2009, 12:12 PM

I have put in thread issues with why support was down. I have submitted this issue to matt before things happen and see it is also not resolved. I will get with matt asap and get this fixed. Sorry for the lack of support but i did report in a thread some personal issues that need urgency.

doc1975 · #6 (**permalink**) Re: SkyLight: Latestthreads Product 06-17-2009, 02:20 PM

I thank you for the update and concern, no worries, just hope all is well with everyone. My site isn't live as of yet, so not detrimental. thanks again.

Mmoore (Support) · #7 (**permalink**) Re: SkyLight: Latestthreads Product 06-23-2009, 08:25 AM

Doc,

did you get this resolved yet ?

doc1975 · #8 (**permalink**) Re: SkyLight: Latestthreads Product 06-23-2009, 02:21 PM

Quote:

Originally Posted by Mmoore (Support)

Doc,

did you get this resolved yet ?

No I haven't, I still have it installed, but have it disabled at this time as I always get the database error if enabled.

Mmoore (Support) · #9 (**permalink**) Re: SkyLight: Latestthreads Product 06-25-2009, 11:46 PM

Here is the new file and it is now fixed. I am sorry that it took for a bit. This is new and updated. Let me know if this gets you resolved. On my test forum it is working fine.

doc1975 · #10 (**permalink**) Re: SkyLight: Latestthreads Product 06-26-2009, 06:38 PM

Quote:

Originally Posted by Mmoore (Support)

Here is the new file and it is now fixed. I am sorry that it took for a bit. This is new and updated. Let me know if this gets you resolved. On my test forum it is working fine.

Same results, slightly different error:

PHP Code:

  Invalid SQL:

 
    ## GET LATEST THREADS ##

    SELECT thread.*,threadid, title, dateline, views FROM acpthread ORDER BY views DESC LIMIT 5;

 
MySQL Error   : Unknown table 'thread'

Error Number  : 1051

Request Date  : Friday, June 26th 2009 @ 11:36:57 AM

Error Date    : Friday, June 26th 2009 @ 11:36:57 AM

Script        : http://www.anticouchpotato.com/forums/index.php

Referrer      : http://www.anticouchpotato.com/forums/admincp/index.php?do=head

IP Address    : 12.10.219.166

Username      : doc1975

Classname     : vB_Database

MySQL Version : 5.0.58

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Skylight vBulletin Skin Released! - 3.8.2 Compatible	Matt	Site News & Anouncements	9	08-16-2010 06:57 PM
Skylight (Brandfree version) Now Fixed!	Matt	Site News & Anouncements	4	06-05-2010 12:13 AM
Skylight Latest Posts	fatal	General Skin Support	12	04-11-2010 04:21 PM
How to install product-traveler_stats ?	micks80	General Skin Support	1	05-31-2009 05:51 PM

Not registered yet?

Welcome to our vBulletin skin support forums!

User Login

doc1975 Customer Joined: Sep 2008 Posts: 27
	#1 (permalink) SkyLight: Latestthreads Product 06-11-2009, 10:05 PM After uploading the xml file and installing, i get the following database error, how to fix?: PHP Code: Database error in vBulletin 3.8.2: Invalid SQL: ## GET LATEST THREADS ## SELECT thread.*,threadid, title, dateline, views FROM acpthread ORDER BY views DESC LIMIT 5; MySQL Error : Unknown table 'thread' Error Number : 1051 Request Date : Thursday, June 11th 2009 @ 03:02:28 PM Error Date : Thursday, June 11th 2009 @ 03:02:28 PM Script : http://www.anticouchpotato.com/forums/index.php Referrer : http://www.anticouchpotato.com/forums/video.php IP Address : 67.190.252.105 Username : doc1975 Classname : vB_Database MySQL Version : 5.0.58 If I go back and disable it, the site functions as should...

AWMGolfer Customer Joined: Jan 2009 Posts: 148
	#2 (permalink) Re: SkyLight: Latestthreads Product 06-12-2009, 07:55 PM Same issue. I am using a different latest threads mod that works fine but I did have the same error showing.

doc1975 Customer Joined: Sep 2008 Posts: 27
	#3 (permalink) Re: SkyLight: Latestthreads Product 06-13-2009, 05:23 PM Bump! Still looking for an answer

doc1975 Customer Joined: Sep 2008 Posts: 27
	#4 (permalink) Re: SkyLight: Latestthreads Product 06-15-2009, 06:34 PM Somehow, i remember support being a bit more useful that it has in the last few days... still looking for a resolution to this issue.

Mmoore (Support) Pre-made Support Joined: Aug 2008 Posts: 1,295
	#5 (permalink) Re: SkyLight: Latestthreads Product 06-17-2009, 12:12 PM I have put in thread issues with why support was down. I have submitted this issue to matt before things happen and see it is also not resolved. I will get with matt asap and get this fixed. Sorry for the lack of support but i did report in a thread some personal issues that need urgency.

doc1975 Customer Joined: Sep 2008 Posts: 27
	#6 (permalink) Re: SkyLight: Latestthreads Product 06-17-2009, 02:20 PM I thank you for the update and concern, no worries, just hope all is well with everyone. My site isn't live as of yet, so not detrimental. thanks again.

Mmoore (Support) Pre-made Support Joined: Aug 2008 Posts: 1,295
	#7 (permalink) Re: SkyLight: Latestthreads Product 06-23-2009, 08:25 AM Doc, did you get this resolved yet ?