Data not inputted into table 'ms_paypublish_nodes'

5 replies [Last post]
kazaa
Offline
Joined: 06/07/2010
Status: 
Answered

Hi,
This module used to work fine on one of my sites. But now i have added it to a new site and when a node is published, the function ms_paypublish_insert_node is not inserting the data into the table.
So this shows on the published node:
"This content will expire in 0 days"
and in your account there is no 'your content' tab.

function ms_paypublish_insert_node($nid, $uid) {
return db_query("INSERT INTO {ms_paypublish_nodes} (nid, uid, status, expiration_date) VALUES (%d, %d, %d, %d)", $nid, $uid, 0, 0);
}

I saw a mention of a 4.0 version with shopping cart function which is also what im after. Is this going to be ready soon?

Many thanks!

kazaa
Offline
Joined: 06/07/2010
i worded that a bit wrong. I

i worded that a bit wrong. I meant to say there is nothing in the 'your content' tab!

Leighton Whiting
Offline
Joined: 06/02/2009
Kazaa, Do you have the

Kazaa,
Do you have the correct permissions set for the user who is trying to view the tab? You need to set the 'view own pay to publish nodes' for users who should be able to see the tab.

Sincerely,
Leighton Whiting

kazaa
Offline
Joined: 06/07/2010
permissions has nothing to do

permissions has nothing to do with writing to a table in a database!
something must have changed in the module file that is causing the problem.

Leighton Whiting
Offline
Joined: 06/02/2009
Ah, I thought you were saying

Ah, I thought you were saying users couldn't even see the tab.

Are there any errors in the log? Have you checked the database table? Are any of the records being written?

Sincerely,
Leighton Whiting

Leighton Whiting
Offline
Joined: 06/02/2009
We got this figured out over

We got this figured out over live chat. It was working, there were just a couple of workflow issues (trying to pay to publish a node that was already existing before the module was installed).

-Leighton

Twitter Feed