Subscriptions

[nogas]

Hi I and having problems with trying to add a Subscriptions read error below??

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: INSERT INTO cp_subscriptions VALUES (NULL, 'Free Ad's For 12 Months', 'Limited Time Only get In Fast Free Ad's For 12 Months To All Members Enjoy! This offer will only last for the next 14 days start date 1-2-2010', '3', '1 year', '7', '0', 'yes');

Result: 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 's For 12 Months', 'Limited Time Only get In Fast Free Ad's For 12 Months To All ' at line 1

Database handle: Resource id #6

[Chuck S]

what version of the software are you using. You can always try redownloading and using adm-misc.php

[nogas]

Chuck you install it on my site goto link Main Index - Racersedgeforums Classifieds

Johnny.

[Chuck S]

Okay when was this a month or so ago? I dont remember the name but then again I deal with so many sites

Basically you can redownload the build and reupload adm-misc.php that should help you out.

[nogas]

I dont no how or where to start doing this thats why I paid you guys to set it all up for me on my site!

Johnny.

[Chuck S]

yes johnny but when was this is what I asked. You can try fixing it by manually editing that file adm-misc.php and make sure lines 4592-4593 are this

Content visible to verified customers only.

[nogas]

Chuck I did that and still not working??
print "$output<br /><br />";
adminfooter();
}

if ($ppaction == "addsub") //# Add a subscription
{

if ($_POST['do'] == "process")
{

// Process a user's subscription submission


$subname = un_htmlspecialchars($subname);
$subdesc = un_htmlspecialchars($subdesc);

$setug = ppmysql_query("INSERT INTO {$Globals['pp_db_prefix']}subscriptions VALUES (NULL, '$subname', '$subdesc', '$subgroup', '$subduration', '$subdays', '$subprice', '$subactive');", $link);
$thesubid = mysql_insert_id( $link );

if ( $thesubid == 0 )
{
diewell( "Error adding new subscription to the database. Returned id was 0." );
exit;
}

[nogas]

I went to delete an old Subscriptions that was in the list and the below come up??

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: UPDATE ibf_members SET member_group_id='4' WHERE id='1'

Result: Unknown column 'id' in 'where clause'

Database handle: Resource id #6

[nogas]

Chuck What do I try next???

[Chuck S]

You can try making those lines this but I wonder why when we already typecast those lines to addslashes that yours are not there.

You sure you uploaded the file and tried inserting a new subscription?


in your ib3.php file in the forums subdirectory line 48 of that file make this line this

Content visible to verified customers only.

[nogas]

I have that in my ib3.php file in the forums subdirectory line 48 you will see it in RED!
whats next to do to fix my problem??

[Chuck S]

Please do not just post our code like that thanks.

As noted make sure the line I am referencing is what is posted in my code block above.

[nogas]

Yes that the code is like your block what next still not working???

[Chuck S]

That would be impossible for you to get the same exact error if you have done the edit I am saying. what is your error?

[nogas]

ok thanks Chuck its now working.....

one more thing now trying to setup a free Subscriptions and I did do a Test Subscription with $0.00 dollars and PayPal not excepting zero $0.00???

Johnny.

[Chuck S]

Because you cant pay someone 0 dollars

[nogas]

So then how do I off ire free Subscription to my Classifieds to my members say for one week??

[Chuck S]

You cant sell a free subscription.


If your trying to allow regular members the ability to upload for a week then give that usergroup upload permissions and in a week remove it.

[nogas]

what about a free listings???

[Chuck S]

You dont have to charge for listings that all depends how your trying to set things up. I can just tell you that you can not anyway sell something for 0 dollars no payment place can take that payment.