The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

Advertisement
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2006, 05:27 PM
cookiepants cookiepants is offline
Junior Member
 
Join Date: Jul 2006
Posts: 15
Geek Article and Review System License Holder 
Default database error when adding product

I think I've read through everything, but apparently not. I had the lite version and LOVED it, and wanted to upgrade. I purchased it last night, downloaded it today.

I have done all the moving files over and cron job, but when I go to add my product, I get this message:

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

				INSERT INTO sewmama_setting
				(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
				VALUES
				(
					'geek_gars_forumids',
					'geek_gars_group',
					'5',
					'',
					'free',
					'',
					100,
					0,
					1,
					'geek_gars'
	);

MySQL Error  : Duplicate entry 'geek_gars_forumids' for key 1
Error Number : 1062
Date         : Monday, July 31st 2006 @ 11:25:55 AM
Script       : http://sewingmamas.com/b/admincp/plugin.php
Referrer     : http://sewingmamas.com/b/admincp/plugin.php?do=productadd
IP Address   : 67.51.162.87
Username     : sewmama_admin
Classname    : vB_Database
And nothing shows up in my admin CP. If I need to chmod something I'm not sure what it is.

Any help is appreciated.

Meg
Reply With Quote
  #2  
Old 07-31-2006, 05:56 PM
cookiepants cookiepants is offline
Junior Member
 
Join Date: Jul 2006
Posts: 15
Geek Article and Review System License Holder 
Default

I hope I did this right...

I deactivated the GARS lite, and chmodded the Geek folder and the geek admin file to 777. Then I refreshed and it was there!

Here's hoping
Reply With Quote
  #3  
Old 07-31-2006, 08:58 PM
cookiepants cookiepants is offline
Junior Member
 
Join Date: Jul 2006
Posts: 15
Geek Article and Review System License Holder 
Unhappy

okay. It worked, but then I got all cocky and wanted to put the updated version on, as I wanted to edit fields.

Now when I went to import the xml file, I get:

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

				INSERT INTO sewmama_setting
				(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
				VALUES
				(
					'geek_gars_forumids',
					'geek_gars_group',
					'|5=3|36=4|22=1|35=1|',
					'',
					'free',
					'',
					100,
					0,
					1,
					'geek_gars'
	),
	(
					'geek_gars_cache',
					'geek_gars_group',
					'',
					'',
					'boolean',
					'yesno',
					100,
					0,
					1,
					'geek_gars'
	);

MySQL Error  : Duplicate entry 'geek_gars_forumids' for key 1
Error Number : 1062
Date         : Monday, July 31st 2006 @ 02:50:54 PM
Script       : http://sewingmamas.com/b/admincp/plugin.php
Referrer     : http://sewingmamas.com/b/admincp/plugin.php?do=productadd
IP Address   : 67.51.162.87
Username     : nutmeg
Classname    : vB_Database
I chmodded everything with a GARS in it to 777. I know geek is gone but I'd love to get this solved or at least some iideas would be appreciated.

Thanks!
Megan
Reply With Quote
  #4  
Old 07-31-2006, 10:01 PM
cookiepants cookiepants is offline
Junior Member
 
Join Date: Jul 2006
Posts: 15
Geek Article and Review System License Holder 
Default

I logged out and in, and there it was -- I think. I'm very confused now. The forum that my members were using for reviews has reverted back to just a regular forum.

thanks!

Meg
Reply With Quote
  #5  
Old 08-01-2006, 08:36 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

You needed to uninstall LITE before you installed this, however those errors shouldnt really affect your running. Just go re-save the settings page in gars and you should be OK
Reply With Quote
  #6  
Old 08-03-2006, 06:37 PM
cookiepants cookiepants is offline
Junior Member
 
Join Date: Jul 2006
Posts: 15
Geek Article and Review System License Holder 
Default

Yep, it's working great now, thanks geek!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
database error beduino Geek Gazette 1 06-24-2008 06:43 PM
Product import error Ramses Geek Article and Review System 3 04-30-2008 01:49 PM
Database error good2laugh Geek Article and Review System 1 08-27-2006 08:35 AM
product install error? pashnit GeekMart 2 12-21-2005 05:55 PM
database error agiacosa Geek Auto-Linker 7 10-15-2005 06:19 PM


All times are GMT. The time now is 07:55 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.