eMoneySpace
Welcome, Guest. Please login or register.
Did you miss your activation email?
News: Welcome to eMoneySpace! Aug 14, 2022 12:51 am




PTC script problem. Save button problem!
Print
Author Topic: PTC script problem. Save button problem!  (Read 1623 times)
eliharold
Reputation: (+7)
*

Offline

Posts: 685
Referrals: 0

View Profile
Apr 15, 2010 01:46 pm

Hi

I have a problem with my ptc site and hopefully can help me sort it out.

The problem is when i attempt to edit a PTC advert or PTR, PTSU and exchange adverts once i click save i get this error.

Database error: Invalid SQL: UPDATE ads SET title='Warpbux', target='http://warpbux.com/index.php?ref=girly101', targetban='http://warpbux.com/banners/banner4.png', username='girly101', credits='0', class='D', views='130', pamount='0.0002', country='', timed='8', bgcolor='', decline='', daily_limit='0', upgrade='', subtitle_on='', subtitle='', icon_on='', views_today='0', forbid_retract='', active='1' WHERE id='38'
MySQL Error: 1054 (Unknown column 'decline' in 'field list')
Session halted.


I get this error whenever i try to edit any adverts on my site. Please if you can sort this out please PM me or reply to this thread.

« Last Edit: Apr 15, 2010 01:57 pm by eliharold » Logged

"Its not about how hard you can hit, but how hard to can GET HIT AND KEEP MOVING FORWARD! Thats how winning is done!" - Rocky
SnoorkAdvertiser
Reputation: (+36)
*

Offline

Gender: Male
Posts: 5075
Referrals: 0


View Profile WWW
Reply #1: Apr 15, 2010 06:29 pm

From what I'm seeing, you are having some errors in your MySQL Database that are causing the problems when you are trying to modify the advertisements on your website. Try repairing the database from your control panel, but I do not guarantee it will resolve the problem. But as I mentioned, the problem interferes with the MySQL Database.
Logged

Snoork Hosting - Enterprise PTC Web Hosting | DDoS Protected
99.9% Network Uptime | 15 Minute Ticket Response Time | 24/7 Live Chat
Check Out Our PTC Web Hosting Specials For Amazing Discounts & Promotions
FJWorld
Reputation: (+45)
*

Offline

Gender: Male
Posts: 6159
Referrals: 42


Let's Work Together!

View Profile WWW
Reply #2: Apr 15, 2010 11:36 pm

What script version are you running?

Your version.txt file is not found.

The error message is telling you that your script is trying to update a field that does not exist in your ads table.

So you have mis-matched script for the database you are using.

Get rid of ....

decline='',

in your sql statement and you should be okay.



« Last Edit: Apr 16, 2010 12:04 am by FJWorld » Logged

maderitescripts

Reputation: (+22)
*

Offline

Posts: 1589
Referrals: 4


NO Lounging

View Profile
Reply #3: Apr 16, 2010 12:50 am

that seems very odd since the decline wasnt in 4.0.3-mr but was in the mrv4 what it is your datbase is missing the decline column in the datbase that allows you give the reason for declining the add


you need to add the field to each table for ads usually this happens when someone uses a script on top of another without the proper installer... Wink

and with no version text hmmm eli what are you up to bro?Huh???
« Last Edit: Apr 16, 2010 12:54 am by maderitescripts » Logged



    War is an ugly thing, but not the ugliest of things. The decayed and degraded state of moral and patriotic feeling which thinks that nothing is worth war is much worse. The person who has nothing for which he is willing to fight, nothing which is more important than his own personal safety, is a miserable creature and has no chance of being free unless made and kept so by the exertions of better men than himself.  (John Stuart Mill)
GPSLite
Reputation: (+13)
*

Offline

Posts: 995
Referrals: 0


View Profile
Reply #4: Apr 16, 2010 01:02 am


and with no version text hmmm eli what are you up to bro?Huh???

I was wondering the same thing after reading op  Shocked
Logged

eliharold
Reputation: (+7)
*

Offline

Posts: 685
Referrals: 0

View Profile
Reply #5: Apr 16, 2010 04:00 am

I was wondering the same thing after reading op  Shocked

that seems very odd since the decline wasnt in 4.0.3-mr but was in the mrv4 what it is your datbase is missing the decline column in the datbase that allows you give the reason for declining the add


you need to add the field to each table for ads usually this happens when someone uses a script on top of another without the proper installer... Wink

and with no version text hmmm eli what are you up to bro?Huh???

Ok thanks for the replies guys.

How do you know i don't have a version.txt i havn't even told you which site i am talking about?

Anyways i am gonna get someone to fix this for me, becuase its too complicated for me.  XD XD
Logged

"Its not about how hard you can hit, but how hard to can GET HIT AND KEEP MOVING FORWARD! Thats how winning is done!" - Rocky
LuckyStarsSites
Reputation: (+48)
*

Offline

Gender: Female
Posts: 3424
Referrals: 11


View Profile
Reply #6: Apr 16, 2010 04:27 am

Ok thanks for the replies guys.

How do you know i don't have a version.txt i havn't even told you which site i am talking about?

Anyways i am gonna get someone to fix this for me, becuase its too complicated for me.  XD XD

I guess they think your site is http://warpbux.com but I assume that's not your site as in the error it shows youre using a ref link.

Yes warpbux's version.txt is missing - http://warpbux.com/version.txt

plus their site info is weird: http://warpbux.com/index.php?view=site_info

Domain: www.warpbux.com
X Exchange: true
Paid To Click: true
Paid To Promote: true
Paid To Signup: true
Paid To Read ads: true
Paid To Read: false
OTMTIwM1NzoTkwY6OnBvIpY2Ym95tzLml2x1ZuZm86o6dHdHJlJ1ZTpTRyd0cnVWU6dHOnVlJ1ZTpnRyd0cnpWU6dHOnVlJ1ZT0c
Logged
friendishan
Reputation: (+64)
*

Offline

Gender: Male
Posts: 4204
Referrals: 6


Meet The Weirdos!

View Profile WWW
Reply #7: Apr 16, 2010 04:33 am

I guess they think your site is http://warpbux.com but I assume that's not your site as in the error it shows youre using a ref link.

Yes warpbux's version.txt is missing - http://warpbux.com/version.txt

plus their site info is weird: http://warpbux.com/index.php?view=site_info

Domain: www.warpbux.com
X Exchange: true
Paid To Click: true
Paid To Promote: true
Paid To Signup: true
Paid To Read ads: true
Paid To Read: false
OTMTIwM1NzoTkwY6OnBvIpY2Ym95tzLml2x1ZuZm86o6dHdHJlJ1ZTpTRyd0cnVWU6dHOnVlJ1ZTpnRyd0cnpWU6dHOnVlJ1ZT0c
weird frusty
Logged

eliharold
Reputation: (+7)
*

Offline

Posts: 685
Referrals: 0

View Profile
Reply #8: Apr 16, 2010 06:17 am

I guess they think your site is http://warpbux.com but I assume that's not your site as in the error it shows youre using a ref link.

Yes warpbux's version.txt is missing - http://warpbux.com/version.txt

plus their site info is weird: http://warpbux.com/index.php?view=site_info

Domain: www.warpbux.com
X Exchange: true
Paid To Click: true
Paid To Promote: true
Paid To Signup: true
Paid To Read ads: true
Paid To Read: false
OTMTIwM1NzoTkwY6OnBvIpY2Ym95tzLml2x1ZuZm86o6dHdHJlJ1ZTpTRyd0cnVWU6dHOnVlJ1ZTpnRyd0cnpWU6dHOnVlJ1ZT0c

yep i guess they did, that was just and exmaple
Logged

"Its not about how hard you can hit, but how hard to can GET HIT AND KEEP MOVING FORWARD! Thats how winning is done!" - Rocky
FJWorld
Reputation: (+45)
*

Offline

Gender: Male
Posts: 6159
Referrals: 42


Let's Work Together!

View Profile WWW
Reply #9: Apr 16, 2010 07:49 am

yep i guess they did, that was just and exmaple

Please accept my apology about the version.txt file.

If you have a problem finding someone to fix your problem let me know and I can provide a solution. I can do what I suggested or what John suggested.
Logged

eliharold
Reputation: (+7)
*

Offline

Posts: 685
Referrals: 0

View Profile
Reply #10: Apr 16, 2010 07:55 am

Please accept my apology about the version.txt file.

If you have a problem finding someone to fix your problem let me know and I can provide a solution. I can do what I suggested or what John suggested.

PMed
Logged

"Its not about how hard you can hit, but how hard to can GET HIT AND KEEP MOVING FORWARD! Thats how winning is done!" - Rocky
eliharold
Reputation: (+7)
*

Offline

Posts: 685
Referrals: 0

View Profile
Reply #11: Apr 17, 2010 12:13 pm

ok i sorted this problem out
Logged

"Its not about how hard you can hit, but how hard to can GET HIT AND KEEP MOVING FORWARD! Thats how winning is done!" - Rocky
Print
 
Jump to:  
Copyright © 2008-2022 eMoneySpace. All rights reserved.