Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4257
Latest: Alex998.
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 43295
Total Topics: 7523
Most Online Today: 186
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 188
Total: 188

Author Topic: Database Error with Scheduled Poster  (Read 3379 times)

0 Members and 1 Guest are viewing this topic.

Offline Tamara

  • Member
  • *
  • Posts: 6
    • View Profile
Database Error with Scheduled Poster
« on: January 05, 2013, 11:56:23 pm »
Helo,

I have installed the Scheduled Poster Mod and it looks very nice. However when wanting to delete a scheduled post I get this Database error:

Unknown column 'ID_FEED' in 'where clause'
File: /homepublic_html/smf/Sources/PostScheduler.php
Line: 396

Can anybody please give me a hint how to fix this please?

Thank you,

Tamara

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16452
    • View Profile
Re: Database Error with Scheduled Poster
« Reply #1 on: January 06, 2013, 02:52:26 am »
Fixed posted a new version to fix this issue.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Tamara

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Database Error with Scheduled Poster
« Reply #2 on: January 06, 2013, 10:22:47 am »
Hello,

thank you. Could you please let me know the code that needs to be fixed so I can manually apply the changes since I also had to manually install the mod.

Thanks!

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16452
    • View Profile
Re: Database Error with Scheduled Poster
« Reply #3 on: January 06, 2013, 10:35:22 am »
This code changed in Sources/PostScheduler.php

New code:
Code: [Select]
function DeletePost()
{
global $txt;

// Get the ID
$id = (int) $_REQUEST['id'];

if (empty($id))
fatal_error($txt['postscheduler_nofeedselected'], false);


DeletePostByID($id);

// Redirect to the Admin
redirectexit('action=postscheduler;sa=admin');

}

function DeletePostByID($id)
{
global $db_prefix;

// Delete the post
db_query("
DELETE
FROM {$db_prefix}postscheduler 
WHERE ID_POST = $id LIMIT 1", __FILE__, __LINE__);


}
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
10 Replies
10518 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
Database Error

Started by pioneer « 1 2 » Support

22 Replies
13081 Views
Last post April 18, 2009, 11:58:55 am
by SMFHacks
5 Replies
6863 Views
Last post January 22, 2010, 11:26:48 am
by SMFHacks
4 Replies
6345 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
1 Replies
921 Views
Last post May 22, 2023, 06:26:18 pm
by SMFHacks

+- Recent Topics

Please Help! by SMFHacks
April 17, 2024, 08:04:55 am

Rate own images by fvlog19
April 11, 2024, 10:56:53 am

Tidy Child Boards on 2.1.4 by SMFHacks
April 04, 2024, 03:54:12 pm

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
March 30, 2024, 12:41:08 pm

Can't DROP 'id_member'; check that column/key exists Datei: by SMFHacks
March 30, 2024, 11:58:20 am

No thumbnails on new uploads by Tonyvic
March 29, 2024, 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

Powered by EzPortal