Welcome Visitor, Please Login or Register Now Friday, March 29, 2024 07:30 AM 
Forums Index > Mewsoft Products > Classifiedawy > Process Expired Ads
New Topic   New Reply
Search for:
Author Message
Focusman01 Focusman01's personal page
Registered Member
Posts: 118 Display member's posts
Joined: 03-29-24 07:30 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Process Expired Ads Edit Delete Reply with quote Quote
First Post Posted on: 08-26-10 01:19 AM next post first post
Hello.

Under Ads Manger, Clicked on Process Expired Ads, this came back:

Processing Expired Ads

Total Expired Ads: 1
Processing...
Content-type: text/html
Software error:
Undefined subroutine &main::ProcessAd called at /xxxx/local/home/xxxxxx/xxxxxxx.com/cgi-bin/class1/AdsMgr.pm line 969.

For help, please send mail to the webmaster (webmaster@xxxxxx.com), giving this error message and the time and date of the error.

I even tried Prune Old Ads under System Maintenance: this appears:

Removing expired ads older than -1 days

0 Ads Found.
Processing Now. Please Wait...

Done.

The ad is still within system,
somewhere, though it is not in the original catagory, just a number 1 by the category, it is being counted but can not be seem.

Any Suggestions?

Thanks
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 07:30 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Process Expired Ads Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 08-27-10 04:56 AM next post previous post
Please update the file Admin.pm, ProcessAds.pm, AdsMgr.pm. For the other topic about categories tree you can update the file DisplayMgr.pm, Main.pm. The new version that has all the previous fixes and updates online if you want to update all the cgi files you will need to click on create sql tables to create the categories zones table.

Mewsoft Support
www.mewsoft.com

Focusman01 Focusman01's personal page
Registered Member
Posts: 118 Display member's posts
Joined: 03-29-24 07:30 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Process Expired Ads Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 08-31-10 10:54 AM next post previous post

Please update the file Admin.pm, ProcessAds.pm, AdsMgr.pm. For the other topic about categories tree you can update the file DisplayMgr.pm, Main.pm. The new version that has all the previous fixes and updates online if you want to update all the cgi files you will need to click on create sql tables to create the categories zones table.



Hello

Just now follwed the step by step above regarding updating Admin.pm, ProcessAds.pm, AdsMgr.pm and DisplayMgr.pm, Main.pm. And then updated all the cgi files.
Went to tried click on create sql tables to create the categories zones table.
This is what came back:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@xxxxxxx.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
--------------------------------------------------------------------------------
Apache/1.3.31 Server at xxxxxxx.com Port xx

No matter what link from admin side is click, the same error message.

I transfer and overwritten files in ASCII mode. I notice within cgi-bin/files mostly all files remain chmod 755, the file ImageSize.pm is 644 anf file Config.cgi is 644. I nave not changed any permissions since you installed the system.

Can you please tell me how to correct the above and also without loosing any customization?

Thanks
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 07:30 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Process Expired Ads Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 09-01-10 07:59 AM next post previous post
You can simply download the latest version from our site, unzip on your computer, then transfer all the cgi-bin/classified/*.pm files in ASCII mode, these updates will not change anything you have done.

Mewsoft Support
www.mewsoft.com

Focusman01 Focusman01's personal page
Registered Member
Posts: 118 Display member's posts
Joined: 03-29-24 07:30 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Process Expired Ads Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 09-01-10 10:13 AM next post previous post

You can simply download the latest version from our site, unzip on your computer, then transfer all the cgi-bin/classified/*.pm files in ASCII mode, these updates will not change anything you have done.



Hello.

Done, same thing came back:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@xxxxxxx.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
--------------------------------------------------------------------------------
Apache/1.3.31 Server at xxxxxxx.com Port xx


But now, no access to admin nor enduser view, completely no access.

From your post on
Thu Dec 16, 2004 11:44 am Post subject:

mewsoft wrote:
Please update the file Admin.pm, ProcessAds.pm, AdsMgr.pm. For the other topic about categories tree you can update the file DisplayMgr.pm, Main.pm. The new version that has all the previous fixes and updates online if you want to update all the cgi files you will need to click on create sql tables to create the categories zones table.

embarrasmentops: What went wrong? Should I have updated the file Admin.pm, ProcessAds.pm, AdsMgr.pm first then test system? second step would have been to update DisplayMgr.pm, Main.pm, and then test system? Third step should had been create sql tables to create the categories zones table, then test system?

I updated all of the above cgi-bin/files at the same time in one step, I think this is where the mistake was? and before updating any file, copy and save in another folder, just incase it is needed to bring you back to the point, right before new update.

For future reference and the next update as not to loose critical info:
I do have one enduser signup, basically a tester of the system for me.

I know I can easly download the latest system and re-install, but if necessary and before doing so,

1. How can enduser info (balance of $$ in there
account, contact info and etc...) be saved and transfer to new install if possible?


2. How can old Customization be transfer with new install ?

3. In regard to file permissions, I guess the best way is to go on server and copy to paper file by file the correct permissions from when you originally installed system?

I hope in the near future, MewSoft writes a book called MewSoft for Dummies smile , or include within documentation. covering all aspects of what if something go's wrong and how to fix, for each system, this would be great for non-tech people.

Just glad things went wrong now, intead of when having actual paying endusers wink

Any input on what must be done, to correct problem? or is it best to start with complete new install?

Thanks
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 07:30 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Process Expired Ads Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 09-01-10 08:38 PM next post previous post
Again updating the cgi files only (*.cgi , *.pm) will not change anything in your system database like users or ads etc.

I guess that you did not update the files properly only, the internal server error can be from 3 issues only in this case:

1)-you did not ransfer the files in ascii mode
2)-you did not set the files permissions to 755
3)-the first line in the *.cgi files is not pointing to perl on your server.

Email me your domain info and I'll check it.

Mewsoft Support
www.mewsoft.com

Focusman01 Focusman01's personal page
Registered Member
Posts: 118 Display member's posts
Joined: 03-29-24 07:30 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Process Expired Ads Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 09-02-10 09:23 AM next post previous post

Again updating the cgi files only (*.cgi , *.pm) will not change anything in your system database like users or ads etc.

I guess that you did not update the files properly only, the internal server error can be from 3 issues only in this case:

1)-you did not ransfer the files in ascii mode
2)-you did not set the files permissions to 755
3)-the first line in the *.cgi files is not pointing to perl on your server.

Email me your domain info and I'll check it.




Fixed, enduser info was saved 8) , thanks, it was the third issue, the first line in the *.cgi files is not pointing to perl on your server.

The following five .cgi files had to be changed:

admin.cgi
admin.cgi.bak
classified.cgi
classified.cgi.bak
Config.cgi

I changed:

1 #!C:\perl\bin\perl.exe
2 #!/usr/bin/perl

To

1 #!/usr/bin/perl
2 #!C:\perl\bin\perl.exe

Now the only concern is your instructions at the end. You will need to click on create sql tables to create the categories zones table.

Went to Setup Wizard, click on create sql tables, this came back:

Auction Categories Zones Table Successfully Created.
Error Creating Ads_Reply Table: Table 'Ads_Reply' already exists.
Error Creating Ads Stats Table: Table 'Ads_Stats' already exists.
Error Creating Announcements Table: Table 'Ads_Announcements' already exists.
Error Creating Ads Table: Table 'Ads' already exists.
Error Creating Ads Cat_ID Index Table: Duplicate key name 'Ads_idx1'.
Error Creating Featured Ads Table: Table 'Ads_Featured' already exists.
Error Creating Invoices Table: Table 'Ads_Invoices' already exists.
Error Creating Invoices index Table: Duplicate key name 'Ads_Invoices1'.
Error Creating Invoices Track Table: Table 'Ads_Invoices_Track' already exists.
Error Creating Pending Users Table: Table 'Pending_Users' already exists.
Error Creating Pending Users Index Table: Duplicate key name 'Pending_Users_idx1'.
Error Creating Users Table: Table 'Users' already exists.
Error Creating Users Index Table: Duplicate key name 'Users_idx1'.
Error Creating Users_Info Table: Table 'Users_Info' already exists.
Error Creating Credit Cards Table: Table 'Credit_Cards' already exists.
Error Creating Ad Views Table: Table 'Ad_Views' already exists.
Error Creating Ad Views Log Table: Table 'Ad_Views_Log' already exists.
Error Creating Ads Favorites Categories Table: Table 'Ads_Favorites_Categories' already exists.
Error Creating Ads Favorites Users Table: Table 'Ads_Favorites_Users' already exists.
Error Creating Ads_Formats Table: Table 'Ads_Formats' already exists.
Error Creating Categories Table: Table 'Ads_Categories' already exists.
Error Creating Categories Name Table: Table 'Ads_Categories_Name' already exists.
Error Creating Categories Description Table: Table 'Ads_Categories_Description' already exists.
Error Creating Categories Meta Table: Table 'Ads_Categories_Meta' already exists.
Error Creating Ads Categories Count Table: Table 'Ads_Categories_Count' already exists.
Error Creating AdsAction Table: Table 'AdsAction' already exists.
Error Creating AdsActionName Table: Table 'AdsActionName' already exists.
Error Creating AdsActionDescription Table: Table 'AdsActionDescription' already exists.
Error Creating AdsLocation Table: Table 'AdsLocation' already exists.
Error Creating AdsLocationName Table: Table 'AdsLocationName' already exists.
Error Creating AdsLocationDescription Table: Table 'AdsLocationDescription' already exists.
Error Creating AuthorTrack Table: Table 'AuthorTrack' already exists.
Error Creating Who's Online Table: Table 'Whos_Online' already exists.
Error Creating Related Categories Table: Table 'Related_Cats' already exists.
Error Creating Bank Accounts Table: Table 'Bank_Accounts' already exists.
Error Creating Deposits Table: Table 'Deposits' already exists.
Error Creating Deposits Index Table: Duplicate key name 'User_ID_idx3'.
Error Creating Transactions Table: Table 'Transactions' already exists.
Error Creating Transactions index Table: Duplicate key name 'User_ID_idx4'.
Error Creating Transactions index1 Table: Duplicate key name 'ID_idx1'.
Error Creating Banner Accounts Table: Table 'Banner_Accounts' already exists.
Error Creating Banner Accounts Index Table: Duplicate key name 'Banner_Accounts_idx'.
Error Creating Banner Campaigns Table: Table 'Banner_Campaigns' already exists.
Error Creating Banner Campaigns index Table: Duplicate key name 'Banner_Campaigns_idx'.
Error Creating Banner Zones Table: Table 'Banner_Zones' already exists.
Error Creating Banner Zones Index Table: Duplicate key name 'Banner_Zones_idx'.
Error Creating Banners Table: Table 'Banners' already exists.
Error Creating Banners Index Table: Duplicate key name 'Banners_idx'.
Error Creating Banner Rotation Index Table: Table 'Banner_Rotation_Index' already exists.
Error Creating Banner Rotation index Table: Duplicate key name 'Banner_Rotation_idx'.
Error Creating Banner Daily Stats Table: Table 'Banner_Daily_Stats' already exists.
Error Creating Banner Daily Stats index Table: Duplicate key name 'Banner_Daily_Stats_idx'.
Error Creating Banner Hourly Stats Table: Table 'Banner_Hourly_Stats' already exists.
Error Creating Banner Hourly Stats index Table: Duplicate key name 'Banner_Hourly_Stats_idx'.
Error Creating Banner Click Log Table: Table 'Banner_Click_Log' already exists.
Error Creating Banner Click Log index Table: Duplicate key name 'Banner_Click_Log_idx'.
Error Creating Mail Lists Table: Table 'Mail' already exists.
Error Creating Mail Email Index Table: Duplicate key name 'Mail_idx1'.
Error Creating Mail Lists Count Table: Table 'Mail_Lists' already exists.
Error Creating Search Terms Table: Table 'Terms' already exists.
Error Creating WatchList Table: Table 'Ads_Watchlist' already exists.
Error Creating WatchList index Table: Duplicate key name 'watch_idx1'.
Error Creating Block List Table: Table 'Block_List' already exists.

I'm thinking the word Duplicate, means that particular table was duplicated, being it dosen't appear in all the tables, only in self selected tables.

The concern is, anywhere Duplicate key name is present, cause any problems rolling within system or mysql?

Thank you again.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 07:30 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Process Expired Ads Edit Delete Reply with quote Quote
Reply #: 7 Posted on: 09-02-10 09:16 PM last post previous post
Good, do not worry about the sql error, the duplicate error just saying it already exist and you are trying to duplicate it but it will not duplicate it so you are fine.

Mewsoft Support
www.mewsoft.com

Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print