Results 1 to 5 of 5

Thread: Database Error on Thread Edit

  1. #1
    Zash's Avatar
    Zash is offline WiredStorm.com - Lightning Fast Web Hosting
    Join Date
    Feb 2009
    Location
    New York, USA
    Posts
    1,137
    Blog Entries
    1
    Thanks
    64
    Thanked 121 Times in 93 Posts

    Database Error on Thread Edit

    I'm trying to edit my thread, and whenever I press 'Save Changes' I get a database error. Opening the editposts.php file directly yields a blank page.

    Thread: http://www.netbuilders.org/web-proxi...read-9673.html
    WiredStorm Hosting Solutions
    █ Lightning Fast Shared and Reseller Hosting
    █ cPanel with Softaculous and 24/7 Email (Ticket) Support
    Biodegradable Sunscreen - Unblock Facebook

  2. #2
    weirdnessme is offline Newbie Net Builder
    Join Date
    Mar 2009
    Posts
    286
    Blog Entries
    1
    Thanks
    19
    Thanked 31 Times in 30 Posts
    May be try and refresh and then edit your post?

  3. #3
    Zash's Avatar
    Zash is offline WiredStorm.com - Lightning Fast Web Hosting
    Join Date
    Feb 2009
    Location
    New York, USA
    Posts
    1,137
    Blog Entries
    1
    Thanks
    64
    Thanked 121 Times in 93 Posts
    Quote Originally Posted by weirdnessme View Post
    May be try and refresh and then edit your post?
    Nope. Quick Edit doesn't work either.

    Update: Edit works on this thread. It just doesn't seem to be working on that thread <.<
    WiredStorm Hosting Solutions
    █ Lightning Fast Shared and Reseller Hosting
    █ cPanel with Softaculous and 24/7 Email (Ticket) Support
    Biodegradable Sunscreen - Unblock Facebook

  4. #4
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,327 Times in 1,258 Posts
    It's definitely thread specific. Every time you try to edit the thread, I get an email like this:
    Code:
    Database error in vBulletin 3.8.4:
    
    Invalid SQL:
    UPDATE post SET
            showsignature = 1,
            allowsmilie = 1,
            title = 'Smowtion - Official Discussion Thread (With payment proof!)',
            pagetext = 'Payment proof of $130 attached below!  This is a LEGITIMATE company!\r\n\r\nMy old review thread was removed for some reason, this is a revised review of Smowtion here - this should be the thread for all conversation.\r\n\r\n--------\r\n\r\nSmowtion is an ad network company that focuses on CPC, CPM, AND CPA ads.  While CPM ads appear most often, it\'s the CPA ads that get you the most money usually.\r\n\r\nThey offer all of the usual ad formats, and ads appear instantly and fill 100% of pageviewes.  Ads on proxified pages ARE allowed.\r\n\r\nThe strange thing about Smowtion is it doesn\'t work well for everybody.  I\'ve been using it all summer, and have done great with it - other\'s report almost no earnings at all.  But I can at least say I am making about 20x as much as I did with AdBrite.\r\n\r\nThe minimum payout is $100, and they ask that you fill out tax info by $20.  The revenue sha
     re is 60% at default, but if you use a link  below, you get 80%.\r\n\r\nRegarding the earnings - my daily average for this month (September 1 - 11) was $1.14 + $5.47 from referrals.  My best performing ad is 300x250.  My average CPM is about .09.\r\n\r\nI never needed support really, but I tried emailing them and I did not get a response (I didn\'t really need it).  I have not tried phoning them, although they do offer multiple toll-free numbers to call for support.\r\n\r\nThey also offer a referral program, where you earn 5% of what your affiliates make for 6 months.\r\n\r\nThey do offer great reporting, allowing you to check earnings based on time, country, ad unit, and compare things like earnings, clicks, and impressions.\r\n\r\n--------------------\r\n\r\nUse the following link if you want to get 80% of ad revenue share instead of 60%:\r\nhttps://publisher.smowtion.com/users/signup/anonymode',
            iconid = 7,
            attach = 0,
            ame_flag = 0
    WHERE postid = 79554;
    
    MySQL Error   : Duplicate entry 'Smowtion - Official Discussion Thread (With payment proof!)-[' for key 'title'
    Error Number  : 1062
    Request Date  : Wednesday, December 9th 2009 @ 07:55:31 PM
    Error Date    : Wednesday, December 9th 2009 @ 07:55:32 PM
    Script        : http://www.netbuilders.org/editpost.php?do=updatepost&p=79554
    Referrer      : http://www.netbuilders.org/editpost.php?do=updatepost&p=79554
    IP Address    : 68.193.195.1
    Username      : Zash
    Classname     : vB_Database_MySQLi
    MySQL Version :
    I just ran a MySQL level DB repair. Give it a try now.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  5. #5
    Zash's Avatar
    Zash is offline WiredStorm.com - Lightning Fast Web Hosting
    Join Date
    Feb 2009
    Location
    New York, USA
    Posts
    1,137
    Blog Entries
    1
    Thanks
    64
    Thanked 121 Times in 93 Posts
    Works now, thanks
    WiredStorm Hosting Solutions
    █ Lightning Fast Shared and Reseller Hosting
    █ cPanel with Softaculous and 24/7 Email (Ticket) Support
    Biodegradable Sunscreen - Unblock Facebook

Similar Threads

  1. how to edit wp default plugin ?
    By SonnyCooL in forum Wordpress
    Replies: 6
    Last Post: 17 May, 2010, 17:08 PM
  2. Javascript page edit
    By Wood_ in forum Community Building
    Replies: 0
    Last Post: 21 April, 2010, 01:11 AM
  3. [Suggestion] DataBase Error in NB.....!!
    By ayebea in forum Announcements and Suggestions
    Replies: 6
    Last Post: 28 October, 2009, 01:24 AM
  4. Need to edit mu posts
    By Mechanical in forum Promoting
    Replies: 0
    Last Post: 20 June, 2009, 10:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •