Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 38

  Posted: Jan 16, 2006 - 07:38 AM

  I am running postnuke 7.6 and also 7.5 sites I have installed amazone ok but I also want to be able to let users write their own reviews on my site.
  
  I read the documentation with amazone but i could not understand what i needed to do.
  
  Can some explain it to me in easy language
  
  thanks

  • 
  •  
• jmvedrine
  
  

  • Rank: Helper
  • Registered: Jan 12, 2004
  • Last visit: Jan 20, 2010
  • Posts: 590

  Posted: Jan 16, 2006 - 12:04 PM

  Included in AmaZone zipfile are several subdirectories with names like "Reviews .750" or "Reviews .761"
  What you need to do is
  - You need to have the Reviews module installed and activated (the one included in PostNuke)
  - replace the files modules/Reviews/index.php and modules/Reviews/admin.php from your server by the ones from the corresponding folder (for instance if you are running PostNuke .761 you will use Reviews .761/index.php and Reviews .761/admin.php to replace the files on your server)
  - add a new field to 2 tables of the Reviews module, for that you can use phpMyAdmin and execute :
  

  Code

  alter table pn_reviews add asin varchar(10) default null;
  alter table pn_reviews_add add asin varchar(10) default null;

  
  If the common prefix of all your tables is not pn_ you need to substitute the right prefix in both lines for instance:
  

  Code

  alter table nuke_reviews add asin varchar(10) default null;
  alter table nuke_reviews_add add asin varchar(10) default null;

  
  if your prefix is nuke_
  That's all
  
  --
  Visit my live reef aquarium.
  
  My Amazon wish list.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 38

  Posted: Jan 20, 2006 - 09:39 PM

  jmvedrine

  Included in AmaZone zipfile are several subdirectories with names like "Reviews .750" or "Reviews .761"
  What you need to do is
  - You need to have the Reviews module installed and activated (the one included in PostNuke)
  - replace the files modules/Reviews/index.php and modules/Reviews/admin.php from your server by the ones from the corresponding folder (for instance if you are running PostNuke .761 you will use Reviews .761/index.php and Reviews .761/admin.php to replace the files on your server)
  - add a new field to 2 tables of the Reviews module, for that you can use phpMyAdmin and execute :
  

  Code

  alter table pn_reviews add asin varchar(10) default null;
  alter table pn_reviews_add add asin varchar(10) default null;

  
  If the common prefix of all your tables is not pn_ you need to substitute the right prefix in both lines for instance:
  

  Code

  alter table nuke_reviews add asin varchar(10) default null;
  alter table nuke_reviews_add add asin varchar(10) default null;

  
  if your prefix is nuke_
  That's all

  
  
  I am in myphpyadmin but I do not have a clue what to do can you give me a simple step by step thanks

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 38

  Posted: Jan 24, 2006 - 06:53 AM

  Can someone give me simple step by step guide to getting reviews working I am a newbie sorry

  • 
  •  
• ainigma32
  
  

  • Rank: Helper
  • Registered: Jan 29, 2004
  • Last visit: Oct 21, 2009
  • Posts: 852

  Posted: Jan 24, 2006 - 07:27 AM

  I think Jean-Michel was pretty clear in his explanation. Which part don't you understand?

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 38

  Posted: Jan 24, 2006 - 08:32 AM

  How do I do this bit
  - add a new field to 2 tables of the Reviews module, for that you can use phpMyAdmin and execute :
  Code:
  alter table pn_reviews add asin varchar(10) default null;
  alter table pn_reviews_add add asin varchar(10) default null;
  
  I have phpMyAdmin but have no idea how to use it
  Sorry go easy on me I a newbie

  • 
  •  
• Slugger
  
  

  • Rank: Expert
  • Registered: Mar 11, 2003
  • Last visit: Oct 21, 2009
  • Posts: 1104

  Posted: Jan 24, 2006 - 09:42 AM

  I was going to send you a script to do this but decided to do you a favor and not send it. Your problem is not that you can't modify the table, it's that you don't know how to modify the table. There's a big difference.
  
  You really should gain at least a very basic knowledge of your database. Afterall, if you can't modify a table, what are the odds you don't know how to back it up or, even if you can back it up, what to do with that backup if you need it?
  
  Better to learn now then later.
  
  phpMyAdmin is for the most part very intuitive and, because it is also well documented, easy to learn. There are literally thousands of online tutorials dedicated to MySQL and once you have a basic knowledge, you'll find at least as many forums to help you get even further. But you've got to get that basic knowledge, yourself.
  
  I suggest you create a database to learn on. That way, if you accidently drop or empty a table, it's no big deal. Once you're no longer afraid of breaking something, you'll be surprised how fast and, for that matter, how much you'll learn. :)
  
  Slugger

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 38

  Posted: Jan 24, 2006 - 09:53 AM

  Thanks Sugger for you helpful advice, I am really new to phpMyAdmin, I will try to find some time to learn how to do it, for now I will leave setting up the review function as unfortunately at moment website s is a hobby rather than my full time job.
  
  Can anyone suggest a good tutorial site
  
  Thanks I will go back to hide behind my newbie rock now :)

  • 
  •  
•  
•  

Users on-line

• slam

This list is based on users active over the last 60 minutes.