Jump to content

JulesInFrance

Member
 View Profile  See their activity

  • Posts

    79

  • Joined

  • Last visited

 Content Type 

Posts posted by JulesInFrance

    System Error Log

    in Install & Upgrade Support

    Posted

    Hi Jules, if you could submit a bug report I would be massively grateful. It may be missed on here otherwise. http://bugs.cubecart.com

    This shouldn't cause too much of a problem with store operation.

    this is v500 issue and the bug system does not support that yet. i raised one nevertheless. hope it helps

    jules

    Slam dunk!

    in Install & Upgrade Support

    Posted

    Hey,

    I just did an upgrade and looked good, bar some system log errors.

    Then I tried to save changes to the Settings. CC5 burped and told me I'd got no license

    Now I log in and all my settings have gone ....

    Bit of a worry?

    Jules

    I subsequently found the following error

    [Error] /home/xxxx/public_html/xxxx/includes/functions.inc.php:416 - Invalid IP address

    System Error Log

    in Install & Upgrade Support

    Posted

    After upgrade I have the following four System Error Log messages.

    Today, 11:47 File: [database.class.php] Line: [403] "ALTER TABLE `sts_CubeCart_inventory` CHANGE `eanupc_code` `upc` VARCHAR( 12 ) NULL" - Unknown column 'eanupc_code' in 'sts_CubeCart_inventory'

    Today, 11:47 File: [database.class.php] Line: [403] "ALTER TABLE `sts_CubeCart_inventory` ADD `ean` VARCHAR( 14 ) NULL AFTER `upc`" - Duplicate column name 'ean'

    Today, 11:47 File: [database.class.php] Line: [403] "ALTER TABLE `sts_CubeCart_inventory` ADD `jan` VARCHAR( 13 ) NULL AFTER `ean`" - Duplicate column name 'jan'

    Today, 11:47 File: [database.class.php] Line: [403] "ALTER TABLE `sts_CubeCart_inventory` ADD `isbn` VARCHAR( 13 ) NULL AFTER `jan`" - Duplicate column name 'isbn'

    Today, 11:47 File: [database.class.php] Line: [403] "ALTER TABLE `sts_CubeCart_inventory` CHANGE COLUMN `updated` `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" - Unknown column 'updated' in 'sts_CubeCart_inventory'

    1) The CC403 sts_CubeCart_inventory table does not have a column eanupc_code, the correct column appears to be eanupcCode

    2) The CC500 sts_CubeCart_inventory table is updated to upc successfully

    3) The CC500 sts_CubeCart_inventory table has a column ean but it does not come after upc, it comes two columns later, after date_added and seo_custom_url

    4) Neither the CC403 sts_CubeCart_inventory table nor the CC500 sts_CubeCart_inventory table has a column called updated

    Can anyone please advise, is this installation unstable?

    Thanks

    Jules

    IPN Error (Module path doesn't exist!)

    in Technical Help

    Posted

    Hi,

    Pulling my hair out to the tune of Paypal (again).

    Users coming back from Paypal to my shop get an Module path doesn't exist! error...

    The URL is => 

    http://www.domain.com/directory/index.php?_g=rm&type=gateway&cmd=process&module=PayPal&cart_order_id=XXXXXX-XXXXXX-XXXX

    Of course there is a configured module at Admin => Modules => Payment Methods => Paypal

    Does anyone have any thoughts on this, please?

    Best regards and many thanks, Jules

    Move to new servers

    in Install & Upgrade Support

    Posted

    Hi, I need to move my site from Domain Name 1 on Server A to Domain Name 2 on Server B

    I think I've worked out that I need to;

    1) move the files

    2) respect file permissions at the new location [*]

    3) edit includes/global.inc.php and reset to permissions to 444

    4) remove includes/extra/key.php

    5) reset the license in my cubcart.com account

    Does anyone know of a decent FAQ with more comprehensive support for this at all, including [*] File Permissions?

    With thanks, Jules

    Edit randomProd.tpl

    in Customising Look & Feel

    Posted

    Hi,

    I want to access the full product image in Skin => Template => Box => randomProd.tpl - then control it's size via XHTML/CSS.

    The current script [v4.3.9] says;

    
	$thumbRootPath	= imgPath($randProd[0]['image'],$thumb=1,$path="root");

	$thumbRelPath	= imgPath($randProd[0]['image'],$thumb=1,$path="rel");

	

	if (file_exists($thumbRootPath) && !empty($randProd[0]['image'])) {

		$box_content->assign("IMG_SRC", $thumbRelPath);

	} else {

		$box_content->assign("IMG_SRC", $GLOBALS['rootRel']."skins/". SKIN_FOLDER . "/styleImages/thumb_nophoto.gif");

	}

    ... as a complete PHP novice I'm guessing $thumbRootPath/$thumbRelPath are just "temporary variables" used in an if/else loop, so I'm guessing $thumb=1 is the determining factor here?

    To get the full image do a I change that variable (and if so, to what?), or remove it altogether?

    Many thanks in advance for your assistance with this matter.

    Regards, Jules

    Customer Type

    in Technical Help

    Posted

    Hi,

    Looking in "Customers" I can see a column called Types.

    These Types are indicated by a icon, like type0.gif,type1.gif & type2.gif...

    The image icon alt tags tell me that Type 0 are Mailing List Only and Type 2 are Full Customer Account.

    But a number of my accounts are trapped in this Type 1 stasis that I do not understand. Can online tell me what happens to an account to determine whether it is a Type 1 or Type 2 account and what needs to happen to facilitate the transition between the two Types?

    With thanks in advance

    JiF

    PayPal Direct Payment under CubeCart 3.0.18

    in Technical Help

    Posted

    I have the same problem as well.

    I tried a search but got 25 pages solving different problems and one suggestion that listed substantial code modifications.

    My guess is that CC3.0.18 simply does not work with Paypal/IPN...

    Like you I'd just like to know what the definitive status on this situation is.

    Here's hoping

    Jules

    Countries

    in Technical Help

    Posted

    I ask because I wish to limit the scope of my store to certain geographical markets. I'm guessing that if I remove all of the countries except the ones I'm interested in that Users outside these territories will not be able to register [billing address] or create shipping addresses?

    Is this the best way to give effect to this or can I limit my users in some more classy way?

    Jules - Yes, if you want customers to only be able to select from a particular set of countries when they register, deleting them is probably the best way (CubeCart does not allow you to hide certain countries)

    Thanks Estelle for taking the time to help; I get it now.

    Jules

    Countries

    in Technical Help

    Posted

    Sorry to be a little thick but I do not fully understand the Countries functionality.

    Is it there solely to support the User Registration, Payment and Postal Address functionality?

    I ask because I wish to limit the scope of my store to certain geographical markets. I'm guessing that if I remove all of the countries except the ones I'm interested in that Users outside these territories will not be able to register [billing address] or create shipping addresses?

    Is this the best way to give effect to this or can I limit my users in some more classy way?

    Thanks,

    Jules

    Categories

    in Technical Help

    Posted

    I created a new 4.3.0 installation today.

    I created one category, one child-category and added one product, that I assigned to the child-category.

    When I use the configuration option to not show categories with no entries I cannot access my product because there's no path through the [empty] category to the child-category.

    When I enable configuration option to show categories with no entries I can access my child-category, with a product count of (0), via the [empty] category. However when I click on the icon for that child category I can access my product.

    Surely this is totally screwed up?

    So I guess this is a bug?

    jiF

    Caching Templates

    in Customising Look & Feel

    Posted

    Hi,

    After a silly half hour wondering why my beautiful new templates do not render correctly on the site I think I discovered that CCRT4 caches templates too.

    Is there a way to turn this behaviour off for development purposes, either officially [ie an option] or un-officially [ie cmod the cache folder to 644]?

    Thanks in advance of any thoughts...

    jiF

    Upgrade Question

    in Install & Upgrade Support

    Posted

    Read Me.txt [2. Upgrade Instructions - version 4.x to latest version 4] is quite clear "Upload the entire contents of this folder over your existing files replacing all existing ones."

    Seems odd; what happens to my settings and photographs?

    can anyone reassure me?

    Brgds, JulesInFrance

    Changing Host

    in Install & Upgrade Support

    Posted

    Thanks B2B'ing and The Happy One!

    In the end I traced it to a limitation of the database import function in phpMySQL - my database was way too large and was truncated during the load.

    I had my host/support load it instead and now we're good-to-go! :yeahhh:

    JiF

    Changing Host

    in Install & Upgrade Support

    Posted

    I need to move my CC4 shop to a host who will support PHP5.

    I loaded CC4.2.0, replaced the images folder with my 4.1.x images folder, copied across global.inc.php, set the permissions and uploaded the DB file.

    Of course I needed to modify global.inc.php to reflect the new host_name in $glob['dbdatabase'] = and $glob['dbusername'] = and I did that too.

    Now I get an error;

    Critical Error: No version history available! Upgrade script doesn't know where to start.

    I'm guessing here but I suspect the CC4 upgrade script should get this from the DB, therefore it is not finding the DB. Would that be a reasonable assumption or is there a more obvious reason for the transfer not working?

    Is there a "moving your v4 installation from one server to another" thread I've missed in my search? :)

    Thanks in advance,

    Jules in France

    Help About Help

    in Technical Help

    Posted

    I do not use CC3 enough to remain fluent.... :D

    I have a store with PayPal/IPN

    As I cannot find a Help Manual or any documentation on the software (anyone?) could someone let me know;

    If I only have PayPal as the payment option

    1. Can the order be marked as Pending (payment method PayPal) even though IPN has not been received? and;

    2. When does an order change from Pending to Processing - is it only after IPN is received.

    With thanks.

    JiF

    So What Does everyone think of ver 4.0 ?

    in Technical Help

    Posted

    I'm really pleased with v4; slightly buggy and with a number of functions that maybe shouldn't be in the wild just yet but overall, for me, this is the start of a new and exciting journey with this software.

    I sell stores to customers who cannot afford Actinic and frankly can't face osCommerce. CCRT4 certainly gives me a lot more to sell, and gives me two versions to pitch to them; shall we call them "4" and "lite".

    Given that many pay$500 for page 1 optimization services merely having SEO makes $129 a decent RoI; and a big thanks to Stevie68 for giving me a neat little list of the key features........

    Yep, I'm really excited and looking forward to the next few releases as the wrinkles come out of it. :(

    Jules

    Import Catalogue Option

    in Technical Help

    Posted

    Derek,

    In attempting to understand the abilities and limitations of the function I made 4 imports of a single record all of which failed for various reasons. The fifth worked. Given that there was a test record included with the default installation my fifth import became record 6.

    This suggests that each import creates a new item in the catalog and subsequent imports cannot be linked to pre-existing records.

    So no, I do not believe you can use the Import function to append to nor update an specific field in an existing record.

    Brgds/Jules

    >>> Thanks for the information.

    Me too - was about to ask the same - forums are good !!!

    Also, will be possible (or is it available) to import just the stock records using this method - i.e. physical stock changes daily (e.g. sell in a real shop, sell on-line).

    So can I just import a CSV file for the stock field ??

    Regards,

    DC

    Martino,

    I had presumed that reference to Master Category ID the Import function can only import to root categories (ie those at the first level, but it's easy enough to test. Having to dive into the database to guarantee the correct category code is certainly not user friendly.... :(

    The Master Category ID is the numeric value of the category you want the item to go in.

    This value is in the CubeCart_category table in the database.

    This will be a real pain, because it means that all the categories are going to have to be created before you can import a catalogue of items. No good if you have a few hundred items to import.

    Haven't played with importing images yet.

    Cheers

    Martin

    Import Catalogue Option

    in Technical Help

    Posted

    2 issues I've come up against so far;

    #1 Master Category ID appears to be a numeric value but whereas I can find the CatalogID of a product that CategoryID is not disclosed anywhere; okay it's easy right now but it could become tricky.

    #2 In the posting below I presumed that Import' would run GD on the referenced files. It does not appear to do so.

    I had to create formatted artwork (ie correct dimensions etc) AND formatted+prefixed (ie "thumb_") thumbnail images for the thumbnails folder. Looks like it's better to Import no artwork and then link to it on a item-by-item basis.

    Thoughts?

    Starting with the easy stuff; it looks like CCRT4 is looking for a flat-file (like unformatted .txt) with each record on it's own row. Each field in the record can be separated by a comma (please, no), a semicolon, a tab or a pipe (my preference). Which you choose depends upon preference but do not use commas if your description field also contains commas........obviously.

    So, select the file on your local HDD, select the field delimiter (as above), check or un-check header rows depending upon whether the first row contains the first record (un-check) or whether the first row contains field descriptions (check), then Upload File.

    CCRT4 will use the information you provided to allow you to make an assignment between the fields in your file and the fixed field structure of (stock) CCRT4; I say "stock" because who knows what impact certain Addons will have on this functionality...

    The fixed field structure calls for data for each of the following;

    Product Code - This I assume to be "Product/Stock#" therefore if left bank CCRT4 will generate a value

    Name - This I assume is "Product Name".

    Description - This will be the description; I'd need to test this to see what happens to HTML tags included in this text, or carriage returns for tab-delimited import files.

    Price - This is a numeric field so only numeric values + decimal point (ie no comma for thousands)

    Sale Price - This is a numeric field so only numeric values + decimal point (ie no comma for thousands)

    Stock Count - This is a numeric field so only numeric values + decimal point (ie no comma for thousands)

    Weight - This is a numeric field so only numeric values + decimal point (ie no comma for thousands)

    Master Image - The "Upload Images" menu option allows users to create an interim (ie pre-GD processing) image folder. The import function requires this be a sub-directory of images/uploads/ and whatever the interim directory is the path must be specified in the image Master Image field

    Master Category ID - So, only a root category may be specified and without testing I would presume that this value must exist already.

    What is missing from the Import function (indeed missing from CCRT4, grrrrr!) is the option to mark added items as disabled until all of the values are added correctly, and everything to do with options, extras and sub-categories.

    I'm planning to give it a shot today.....wish me luck.. :wacko:

    Hi,

    With reference to the 'Import Catalogue' option in the Admin section, is there any information available anywhere as to how the import file should be formatted eg: information required, order of columns etc.

    Cheers

    Martin

×
×
  • Create New...