Jump to content

Auto instock update Mod with extras


Recommended Posts

  • 2 weeks later...
Guest lilithfiend

Hi you all, I'm having some problems with this mod. Can anyone help?

I've installed it and it went fine. I already have products in my store and after installing the mod, I tried inserting the number of stock available. That can be done with no problems. However, on the product page it says: We have in our inventory. Is this correct? Or is there supposed to be a number that makes it: We have 20 in our inventory.

The problem that I'm having is this: when I try inserting new products, it says that the product has been inserted successfully. However, when I click on "View URL", I get an error message that says: The product you are trying to view no longer exists in our database!

I assume this has something to do with mySQL database. I've already followed the instructions and inserted this line into the store_inventory table:

ALTER TABLE `prefix_store_inventory` ADD `instock` INT( 30 ) DEFAULT '100' NOT NULL ;

Can someone tell me what to do?? Any help would be greatly appreciated!

Link to comment
Share on other sites

Guest stijnj

lilithfiend

i will debug this mod completely so that once and for all this mod is bugfree

9 pages of replies for 1 mod is far enough :errm:

I'll post the bugfree version 4or 5 of august

Stijn

Link to comment
Share on other sites

well down loaded the new version from site

go to insert

$sql = 'ALTER TABLE `store_inventory` ADD `instock` INT( 30 ) DEFAULT \'0\' NOT NULL ; ';

looking at it I do not have a table store_inventory only inventory

Ever Im being dum today or I have missed something

And when I go into admin edit product I get errors

Link to comment
Share on other sites

Guest stijnj

looking at it I do not have a table store_inventory only inventory

well that would be a big surprise ! :errm:

from cubecart.sql :

#

# Table structure for table 'store_inventory'

#

CREATE TABLE store_inventory (

  product varchar(60) NOT NULL default '',

  quantity int(16) NOT NULL default '1',

  description text NOT NULL,

  image varchar(250) NOT NULL default '',

  price decimal(30,2) NOT NULL default '0.00',

  title varchar(250) NOT NULL default '0',

  cat_id int(16) NOT NULL default '0',

  popularity int(64) NOT NULL default '0',

  sale_price decimal(30,2) NOT NULL default '0.00',

  PRIMARY KEY  (product),

  UNIQUE KEY product (product)

) TYPE=MyISAM;

Link to comment
Share on other sites

Thanks stijnj

Added store_inventory to sql

Just get this error mmm... some days you just wish you did not get out of bed

admin/edit_product.php on line 455

If anyone as any ideas

Thank you for your time

Link to comment
Share on other sites

I have no mods my friend

Torecap when click on admin-product-edit I get

Error

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /homepages/xx/xxxxxxxx/htdocs/www.somesite.com/admin/edit_product.php on line 456

line 456

echo"<tr bgcolor=\"$colour_3\">

<td width=\"200\" valign=\"top\"><b>$la_norm_pri</b></td>

<td width=\"400\" valign=\"top\">$currency<input class=\"textbox\" type=\"textbox\" name=\"price\" value=\"$price\"><font color=\"990000\"><b>*</b></font></td>

</tr>

Link to comment
Share on other sites

Guest stijnj

read the error : expecting ',' or ';'

the line just before 456

does it read

echo"</select><font color=\"990000\"><b>*</b></font></td></tr>";

or

echo"</select><font color=\"990000\"><b>*</b></font></td></tr>

should read as the first ! you probably forgot the closing tags ";

Link to comment
Share on other sites

Thanks found where I missed the ";

Going off the subject for a min

Just had a look at your site and like the completed mod site is it a simple down load and click install and will I have to clear all my database before installation

Seems the way to go for me as its got all the mods I want and will save my time messing about

Thanky you again for the extra pair of eyes :errm:

Link to comment
Share on other sites

i juz downloaded the file.. have some problems.. cant seem to find my store_inventory database file.. can someone tell me where is it? thank you.

Link to comment
Share on other sites

help!! i am totally lost.. created a database in phpMyAdmin.. how do i delete it away? i'm still lost on how to go about creating a new row in my store_inventory database file called instock...

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.



×
×
  • Create New...