• eCommerce
  • Social and Community Suite
  • Content Management
  • RSS Extensions
  • VirtueMart Extensions
Follow us on Twitter   Join The Factory on the New Digg  
(0) | Login | Register | Lost Password?
Username: Password:  
Home
Our Products
Joomla 1.7.x  (23) & J!1.6.x
Joomla 1.5.x (28)
Joomla 1.0.x (17)
Factory Club Extensions (7)
Drupal, Elxis, MODx (6)
Windows Gadgets for J! (11)
Free Templates (4)
All Products (92)
Documentation
Tweets
Forum
Contact Us
Terms & Conditions
How to Buy Guide
Customers FAQ's
Updates & Upgrades
About Us
The Factory Demo Server for Joomla Extensions
Money Back Guarantee
Payment Methods for Joomla Extensions
Follow us on Facebook

Latest Tweets

  • Join us at the Joomladay UK!
  • The Factory Extensions Joomla Compatibility Chart
  • Love Factory 2.4 for Joomla 1.7
  • Love Factory - Memberships [VIDEO]
  • Love Factory - Custom Fields Integration [VIDEO]
  • Love Factory - Google Maps Integration [VIDEO]
  • Love Factory - Administrator Guide [VIDEO]
  • Love Factory - Memberships
  • Collection Factory for Joomla 1.6 with CB support
  • Reverse Auction Factory 1.5.9
 
   Home   Help Search Login Register  
The Factory > Forum > eCommerce Factory Suite for Joomla CMS. > Raffle Factory > Database error
Pages: [1]
« previous next »
  Print  
Author Topic: Database error  (Read 2231 times)
analustia
Newbie
*
Posts: 2


View Profile
Database error
« on: September 09, 2009, 06:56:29 pm »

"New raffles" and "Search" i am getting the follwoing database errors:

"New raffles":

No valid database connection Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei '' in Zeile 1 SQL=select name from jos_bid_payment where id=

"Search"

No valid database connection Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'WHERE = ''' in Zeile 1 SQL=SELECT * FROM WHERE = ''

What shall I do?

Thanks
Analustia
Logged
Factory Staff 02
The Factory Staff
Hero Member
*
Posts: 1912



View Profile
Re: Database error
« Reply #1 on: September 10, 2009, 08:37:49 am »

Hi,

This is an error reported in JoomFish.
Recently some fixes in this type of manner were made. If you have the latest remake of Raffle 1.1.0 (meaning you download it recently )  and still have this issue pls send support your site credentials (super admin account and write permissions to the raffle component files )


Cheers,
Sorin
Logged

The Factory's Development Team member.
bachcuc
Newbie
*
Posts: 9


View Profile
Re: Database error
« Reply #2 on: December 07, 2009, 04:00:11 am »

Hi,

I'm testing Raffle Factory 1.1.0 with Joomla and JoomFish and I have the same problem as the poster above.

Here's what I have in 'Search' and 'New Raffle' :

No valid database connection 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 'WHERE = ''' at line 1 SQL=SELECT * FROM WHERE = ''

Thank you very much for your help.

Bach Cuc
Logged
Factory Staff 02
The Factory Staff
Hero Member
*
Posts: 1912



View Profile
Re: Database error
« Reply #3 on: December 07, 2009, 11:04:21 am »

Hi bachcuc, analustia ,

  I' ve made today a remake of the current Raffle version that includes the fixes to the Search page and other issues.

Pls ask for the today remake and overwrite the files from thefactory/ and models/ folders and bids.php.

Cheers,
Sorin

Logged

The Factory's Development Team member.
Factory Staff 02
The Factory Staff
Hero Member
*
Posts: 1912



View Profile
Re: Database error
« Reply #4 on: December 10, 2009, 10:28:49 am »

@bachcuc
Replace the file attached with the existing in the models.
Sorry it slipped at debugging.

Sorin
Logged

The Factory's Development Team member.
bachcuc
Newbie
*
Posts: 9


View Profile
Re: Database error
« Reply #5 on: December 14, 2009, 01:15:50 am »


Thank you very much for you help. I don't have problems with the 'Search' page and 'New Raffle' page any more.

I have enabled the payment with paypal. And after having paid through Paypak,  when I want to save a new Raffle, I have the following message :

Fatal error: Call to undefined function ValidateSaveAuction() in /mnt/162/sdb/5/a/biztombola/components/com_bids/plugins/pricing/price_listing.php on line 60

Can you help me please to find out what's going on ?

Thank you very much again for your help.

Bach Cuc
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Loading...
Joomla Extension - RSS Factory Manager  Joomla Extension - EBook Factory  Joomla Extension - Briefcase Factory  Joomla Extension - Auctions Factory  Joomla Module - RSS Contextual  Joomla Module - Exchange Factory (Europe / EURO)  Joomla Module - Exchange Factory (Romania/ RON)  Joomla Custom Extensions Development   Free Joomla Extensions  Joomla Extension - RSS Factory Pro (Enhanced Version)  Joomla Virtuemart Payment Plugin - Gecad (EPayment.ro)  Joomla Module - Mosimage / Image Module  Joomla Extension - Reverse Auction Factory (Lowest Bidder Auctions)  Joomla Extension - Article Factory Manager  Joomla Module - Lavalamp Menu  Joomla Module - RSS Image Extractor  Joomla Module - Exchange Factory (Europe / EURO) for Joomla 1.0.15  Joomla Module - Exchange Factory (Romania / RON) for Joomla 1.0.15  Joomla Module - Top Movies (IMDB)   Joomla Module - EBay Latest Auctions  Auction Factory Standalone PHP script