Forums Index > Mewsoft Products > Searchawy > downloading or viewing reports
infoxxl First Post Posted on: 08-03-11 10:37 PM
downloading or viewing reports

Hi again, sorry for posting so many help requests. When I try to get a report to download or to view, I receive following message

SQL Error: 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 'AND Hit_Date>=978325200 AND Hit_Date<=978411599' at line 1
Query:
SELECT Keyword, Price, Num_Hits, Hit_Date FROM Clicks WHERE ID = AND Hit_Date>=978325200 AND Hit_Date<=978411599
Line 165, File /home/ik/public_html/cgi-bin/dir/reports.pm.

-------------------------------------------------------------------------------------------------------

when I click on the currency converter on the home page, I receive following message as well as on the other portal tools :

Software error:

Can't locate Finance/QuoteHist/SiliconInvestor.pm in @INC (@INC contains: /home/ik/public_html/cgi-bin/dir . /usr/lib/perl5/5.8.7/i686-linux /usr/lib/perl5/5.8.7 /usr/lib/perl5/site_perl/5.8.7/i686-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl .) at finance.cgi line 138.\
BEGIN failed--compilation aborted at finance.cgi line 138.\

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

Thanks, Vince
mewsoft Reply #: 1 Posted on: 08-04-11 07:17 AM
Re: downloading or viewing reports

The first error, you need to add a link and select it to download its report, the error shows no link ID.

The second error ask you hosting to install perl module Finance::QuoteHist, see your testserver.cgi for all modules.


Mewsoft Support
www.mewsoft.com
infoxxl Reply #: 2 Posted on: 08-04-11 11:49 AM
Re: downloading or viewing reports
 
mewsoft's Wrote:
 

The first error, you need to add a link and select it to download its report, the error shows no link ID.

The second error ask you hosting to install perl module Finance::QuoteHist, see your testserver.cgi for all modules.

Hi, thanks again, but how do I add a link for the first error?
Thanks, Vince
infoxxl Reply #: 3 Posted on: 08-04-11 04:56 PM
sorry
 
mewsoft's Wrote:
 

The first error, you need to add a link and select it to download its report, the error shows no link ID.

The second error ask you hosting to install perl module Finance::QuoteHist, see your testserver.cgi for all modules.

Oops...sorry, I guess you meant a new listing has to been added...right?

Bye, Vince
mewsoft Reply #: 4 Posted on: 08-04-11 06:51 PM
Re: downloading or viewing reports
Yes sure.

Mewsoft Support
www.mewsoft.com