XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module usage questions 
  4.  / Best way to have review module for products
Register
11
ghia
Re: Best way to have review module for products

  • 2010/1/8 15:50

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


AFAIK It is the last version.
12
deepak267
Re: Best way to have review module for products

  • 2010/1/8 16:53

  • deepak267

  • Quite a regular

  • Posts: 352

  • Since: 2008/8/15


Thanks Ghia
13
deepak267
Re: Best way to have review module for products

  • 2010/1/10 22:20

  • deepak267

  • Quite a regular

  • Posts: 352

  • Since: 2008/8/15


Hi all,

Finally I used myreview 2.1 RC on my website. and it is working great.

I have to change few things:

1. Replaced $_POST, $_GET for PHP5 compatibility
2. Customised few template to display the review count
3. Minor changes to block for look and feel.

I found one error, when you update a review, it need an admin approval. However when when you try to approve the review, it gives the following sql error on the debug window.

------------
SELECT uname, email FROM xoops_users WHERE uid=
Error number: 1064
Error message: 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 '' at line 1
------------
This is because, when it is inserting the record into db_myreview_mod, the value of db_myreview_mod.lid is set to zero.

Let me know if you know the fix, else I will debug this sometime next week and post the solution.

Thanks in advance.

Deepak

14
deepak267
Re: Best way to have review module for products

  • 2010/1/10 23:13

  • deepak267

  • Quite a regular

  • Posts: 352

  • Since: 2008/8/15


i have just noticed another strange behaviour, the thumb image is not displayed on the side - right block Best rated products. even i have selected to display the image. and surprisingly, it work perfectly fine on my test system.

Test system = Windows
Production = Linux (shared hosting)

Any idea why?

Thanks in advance
15
deepak267
Re: Best way to have review module for products

  • 2010/1/11 0:10

  • deepak267

  • Quite a regular

  • Posts: 352

  • Since: 2008/8/15


Quote:

i have just noticed another strange behaviour, the thumb image is not displayed on the side - right block Best rated products.


I am not sure why, i found that it did not create the thumb images for the first 3 product uploads. Only for those three I created the thumbs manually and uploaded (you call it as a data fix).

However now it is creating the thumbs and working fine. Hope it will work in future.

Thanks

Deepak
16
ghia
Re: Best way to have review module for products

  • 2010/1/11 1:54

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Permission of the image directory?
17
deepak267
Re: Best way to have review module for products

  • 2010/1/11 10:15

  • deepak267

  • Quite a regular

  • Posts: 352

  • Since: 2008/8/15


Hi Ghia,

I dont think, it was due to permission because i did not change anything and it worked after 1st 3 review. I will watch the performane and post my finding.

Thanks for your help.

« 1 (2)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

331 user(s) are online (263 user(s) are browsing Support Forums)

Members: 0

Guests: 331

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits