Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme

User Box

Anonymous

38.107.179.219

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ? This s...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriously...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Sql errors + thanks stuff not working

Sql errors + thanks stuff not working
Goto page 1, 2 Next

20 Replies / 1198 Views


www.clanthemes.com Forum Index » Bugs/Issues	View previous topic :: View next topic

OBTeo
Reputation: 15.4
Local time: 1:08 PM
Location: Milano

Armour Whore

0.09 posts per day
Medals: 0

Joined: Mar 16, 2011
Last Visit: 16 May 2012
Posts: 41
Points: 5171

Sql errors + thanks stuff not working Posted: Tue Jan 17, 2012 2:14 pm
Shop Purchases:Multiple Gamer Evo · Multiple Gamer Xtreme

Hi Ped, in the Xtreme theme i bought there are always these errors in log:

Code:

---------[SQL Error]------------------------------------------------------------------------------------------------------------
- [17 Jan 2012 - 05:23:58] -
User: Anonymous
IP: 66.249.71.110
URL: /modules.php?name=Forums&file=show_post&p=439&view=previous

File: /home/sofmodsc/public_html/modules/Forums/show_post.php
Line: 94
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND post_time <
ORDER BY post_time DESC
LIMIT' at line 3
Code: 1064
Query: SELECT post_id FROM nuke_bbposts
WHERE topic_id =
AND post_time <
ORDER BY post_time DESC
LIMIT 1
---------------------------------------------------------------------------------------------------------------------------------

---------[Message die() called multiple times]------------------------------------------------------------------------------------------------------------
- [17 Jan 2012 - 05:23:58] -
User: Anonymous
IP: 66.249.71.110
URL: /modules.php?name=Forums&file=show_post&p=439&view=previous

Error Code: 202
Error Message : Could not obtain newer/older post information
Error Title:
Error Line: 96
Error File: /home/sofmodsc/public_html/modules/Forums/show_post.php
Error SQL: SELECT post_id FROM nuke_bbposts
WHERE topic_id =
AND post_time <
ORDER BY post_time DESC
LIMIT 1

-----------------------------------------------------------------------------------------------------------------------------------------------------------

and Thanks stuff doesnt work!

can u help me? thx

http://www.sof2mods.com Multiplayer Community Soldier Of Fortune 2 Call of Duty: Modern Warfare 3 Call of Duty: Black Ops 2 Battlefield 3

Ped
Reputation: 94
votes: 37
Local time: 1:08 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 26 May 2012
Posts: 3675
Points: 191995

Re: Sql errors + thanks stuff not working Posted: Tue Jan 17, 2012 5:59 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Thats a tricky one as its your forums, its nothing to do with the theme

Have you installed any forum mods ?

OBTeo
Reputation: 15.4
Local time: 1:08 PM
Location: Milano

Armour Whore

0.09 posts per day
Medals: 0

Joined: Mar 16, 2011
Last Visit: 16 May 2012
Posts: 41
Points: 5171

Re: Sql errors + thanks stuff not working Posted: Wed Jan 18, 2012 8:28 am
Shop Purchases:Multiple Gamer Evo · Multiple Gamer Xtreme

Thanks mod is working with another theme not with this one, and btw is a new installation of nuke evo xtreme, I only imported the database from my old site in basic nuke evo, naturally modified for this new vertion.

the only mod that I installed in the new Xtreme is: the last visit
but I put it only yesterday afternoon and i see this SQL error since I installed the xtreme vertion. every day I have to delete it from the log.

Ped
Reputation: 94
votes: 37
Local time: 1:08 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 26 May 2012
Posts: 3675
Points: 191995

Re: Sql errors + thanks stuff not working Posted: Wed Jan 18, 2012 9:06 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

I just looked in the viewtopic_body.tpl and the thank you button / code is there,

Code:

<a href="{thanks_button.U_THANK_TOPIC}"><img src="{thanks_button.THANK_IMG}" border="0" alt="{thanks_button.L_THANK_TOPIC}" align="middle" /></a>

have you turned the thank mod off ?

If you go to your forums admin area and edit a category yoursite.com/modules/Forums/admin/admin_forums.php , select a category and scroll down a bit it says

Allow to Thank posts YES / NO

is yours set to YES ?

Ped
Reputation: 94
votes: 37
Local time: 1:08 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 26 May 2012
Posts: 3675
Points: 191995

Re: Sql errors + thanks stuff not working Posted: Wed Jan 18, 2012 9:13 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Ive also just tested it on my version and its working, so you must have done something

All I can suggest is re-download the theme and re-upload the forums folder (you could just try re-uploading the viewtopic_body.tpl file)

If that doesn't work then your have messed up your database Confused

OBTeo
Reputation: 15.4
Local time: 1:08 PM
Location: Milano

Armour Whore

0.09 posts per day
Medals: 0

Joined: Mar 16, 2011
Last Visit: 16 May 2012
Posts: 41
Points: 5171

Re: Sql errors + thanks stuff not working Posted: Wed Jan 18, 2012 10:23 am
Shop Purchases:Multiple Gamer Evo · Multiple Gamer Xtreme

thank mod is on... anw i look into it right now, maybe is something in the database because i didnt edit the viewtopic_body.tpl that way.

about the sql errors can u help me? got u any ideas?

Ped
Reputation: 94
votes: 37
Local time: 1:08 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 26 May 2012
Posts: 3675
Points: 191995

Re: Sql errors + thanks stuff not working Posted: Wed Jan 18, 2012 12:51 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Whats the link to this MOD that you added "last visit"

OBTeo
Reputation: 15.4
Local time: 1:08 PM
Location: Milano

Armour Whore

0.09 posts per day
Medals: 0

Joined: Mar 16, 2011
Last Visit: 16 May 2012
Posts: 41
Points: 5171

Re: Sql errors + thanks stuff not working Posted: Wed Jan 18, 2012 4:22 pm
Shop Purchases:Multiple Gamer Evo · Multiple Gamer Xtreme

i had the SQL errors b4 the adding......

btw i added this one:
http://www.clanthemes.com/downloaddetails-73-766--last-visited-111.html

and it has nothing to do with the errors.

Ped
Reputation: 94
votes: 37
Local time: 1:08 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 26 May 2012
Posts: 3675
Points: 191995

Re: Sql errors + thanks stuff not working Posted: Wed Jan 18, 2012 4:45 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Have you asked Killigan over at Xtreme ?

OBTeo
Reputation: 15.4
Local time: 1:08 PM
Location: Milano

Armour Whore

0.09 posts per day
Medals: 0

Joined: Mar 16, 2011
Last Visit: 16 May 2012
Posts: 41
Points: 5171

Re: Sql errors + thanks stuff not working Posted: Thu Jan 19, 2012 12:13 pm
Shop Purchases:Multiple Gamer Evo · Multiple Gamer Xtreme

not yet, could be an idea, thx m8.

Ped
Reputation: 94
votes: 37
Local time: 1:08 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 26 May 2012
Posts: 3675
Points: 191995

Re: Sql errors + thanks stuff not working Posted: Thu Jan 19, 2012 1:00 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

OBTeo wrote:

not yet, could be an idea, thx m8.

Its definatly not a theme problem, its a site problem be it database or site settings or even server who knows

The error refers to the time and date of users forum posts, so its getting confused or missing something, finding where the problem is, is not going to be a simple one

I would ask over at Xtreme first as its there CMS and they may know the answer already

Have you looked over your forum cookie settings ?

OBTeo
Reputation: 15.4
Local time: 1:08 PM
Location: Milano

Armour Whore

0.09 posts per day
Medals: 0

Joined: Mar 16, 2011
Last Visit: 16 May 2012
Posts: 41
Points: 5171

Re: Sql errors + thanks stuff not working Posted: Sun Jan 22, 2012 11:43 am
Shop Purchases:Multiple Gamer Evo · Multiple Gamer Xtreme

yes i did mate, cookies r set up fine as the old post said! thx again i asked at nuke Xtreme too but i had no reply. He thinks i got no the nuke xtreme because of the copyright at bottom of the page.. anw i replyed right now a new post, maybe he can help me, if i will fix it i will post here too.

www.clanthemes.com Forum Index » Bugs/Issues

20 Replies / 1198 Views
Page 1 of 2
All times are GMT
Goto page 1, 2 Next

Display posts from previous:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work