Printable Price list :: support thread

[MMSAachen]

Hey evrybody,
@paulm:
thanks for your interest in my problem, so i tryed the v1.4 that you attached in your posting, but now i become the following error (method copy&past):

1064 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 '1', '2', '3' ),' )' at line 1
in:
[INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function ) VALUES ( 'Default Profile', 'PL_DEFAULT_PROFILE', '1', 'Choose the default profile to use.', @pricelistid , 10, NULL , 'zen_cfg_select_option(array('1', '2', '3' ),' );]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

.
If i do it with PHPMyAdmin i becom the folowing error:

# Profiles
# Profile 1
INSERT INTO `configuration_group`
VALUES (
NULL , 'Price-list Profile-1', 'Settings for printable price-list profile-1.', @sortorder +2, 1
);

MySQL meldet: Dokumentation
#1136 - Column count doesn't match value count at row 1

.

am i wrong with all them what i do????

[paulm]

It looks like your MySQL version (can you tell me what MySQL version you are using?) does not allow this syntax:

INSERT INTO `configuration_group`
VALUES (
NULL , 'Price-list Profile-1', 'Settings for printable price-list profile-1.', @sortorder +2, 1
);

but needs the names of all the columns. I fixed this for the other error you posted about, but I did not realize there where more lines having the same problem. Sorry about that

Attached 1.4.1 to this post (only change compared to 1.4 is the pricelist-3.sql fix ), hopefully this time it's really fixed.

(will remove v1.4)

[MMSAachen]

Hi everyone,
first of all thanks so mauch paul it works lovely, thank you for wosting your time to fix the SQL. So with C&P didn't work, but with PHPmyadmin. So now i have a pricelist thats nice, the one thing is i can't found the entery Pricelist no where in the admin section???? wether in the alternativ view, question: Should i do something in the admin folder some changes the in the file that i downloaded, are only include file changes!!!
thanks allot

[MMSAachen]

Hi egain,
yes peapel it's me again so i have one more quetion, i'm trying to customise the pricelist, so my quetion is, can i change the quantity entery in jpg like its in the shop (red yellow green [Ampelsystem] so i don't know how it call#s in english) so witsh file should i change??? I think its the (TABLE_HEADING_SOH) but where can i found it??

[MMSAachen]

Hi evryone,
so im stell have the same question, i'll be happy if some one can help, so thank you.

[Fluffy Bunny]

EDIT:

It works great, is there any way to add a small thumb image next to it, so that is like a printable catalogue?

[blag]

I installed the version in the Downloads section, but I see that there is a version 1.4.1 of this mod in this thread. Is the 1.4.1 the latest version?

AFAIK I have successfully installed the mod, but I am not entirely clear how the user (Including the webmaster) prints just the required output because there doesn't seem to be a 'printer-friendly' or a 'print' button. Please, could someone explain how to print?