PC Configurator Module [Support Thread]

[tvwright]

I have been trying to get this SQL patch installed correctly but I keep running in to this syntax error...any insights.

1064 You have an error in your SQL syntax near 'ON DUPLICATE KEY UPDATE configuration_key = configuration_key' at line 1
in:
[INSERT INTO wcs_configuration VALUES ('', 'Activate and Select Product Group for Field No 1', 'PRODUCTS_GROUP_PC_CONFIGURATOR_1', 'off', '
Select from the drop down list, which Product Group you want to display in this field in the Shop PC Configurator Table.
\
The Default Value selected on the drop down list with Product Option Names for this products group field in the Shop will be exactly as it shows here.

The Sort Order for this products group field in the Shop will also be exactly as it shows here.

So, PC Configurator in the Shop will be like an image of this screen. You can change these values whenever you want, without affecting the functionality of PC Configurator but only customers options and sort order.

The fields you do not want to display in Shop PC Configurator, should have the value "off" (default)
', 9453, 1, now(), now(), NULL, 'zen_cfg_select_drop_down(array (array(''id''=>''off'', ''text''=>''off''), array(''id''=>''Computer Case'', ''text''=>''Computer Case''), array(''id''=>''Intel Motherboard'', ''text''=>''Intel Motherboard''), array(''id''=>''AMD Motherboard'', ''text''=>''AMD Motherboard''), array(''id''=>''Intel Proccesor'', ''text''=>''Intel Proccesor''), array(''id''=>''AMD Proccesor'', ''text''=>''AMD Proccesor''), array(''id''=>''Ram Memory'', ''text''=>''Ram Memory''), array(''id''=>''Extra Ram Memory'', ''text''=>''Extra Ram Memory''), array(''id''=>''Graphics Card - VGA'', ''text''=>''Graphics Card - VGA''), array(''id''=>''Floppy Disk Drive'', ''text''=>''Floppy Disk Drive''), array(''id''=>''Hard Disk Drive'', ''text''=>''Hard Disk Drive''), array(''id''=>''Extra Hard Disk Drive'', ''text''=>''Extra Hard Disk Drive''), array(''id''=>''CD ROM - DVD ROM'', ''text''=>''CD ROM - DVD ROM''), array(''id''=>''DVD RW - CD ROM'', ''text''=>''DVD RW - CD ROM''), array(''id''=>''Keyboard'', ''text''=>''Keyboard''), array(''id''=>''Keyboard + Mouse SET'', ''text''=>''Keyboard + Mouse SET''), array(''id''=>''Mouse'', ''text''=>''Mouse''), array(''id''=>''Display Monitor'', ''text''=>''Display Monitor''), array(''id''=>''Sound Card'', ''text''=>''Sound Card''), array(''id''=>''Speakers'', ''text''=>''Speakers''), array(''id''=>''Modem - Fax'', ''text''=>''Modem - Fax''), array(''id''=>''Extra PC Parts'', ''text''=>''Extra PC Parts''), array(''id''=>''Other Extra Options'', ''text''=>''Other Extra Options''), array(''id''=>''Operating System'', ''text''=>''Operating System''), array(''id''=>''Power Supply'', ''text''=>''Power Supply''), array(''id''=>''Printer'', ''text''=>''Printer''), array(''id''=>''Scanner'', ''text''=>''Scanner''), array(''id''=>''Software/Applications'', ''text''=>''Software/Applications''), array(''id''=>''Support Services/Internet Services'', ''text''=>''Support Services/Internet Services'')),') ON DUPLICATE KEY UPDATE configuration_key = configuration_key;]
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.

[lebrand2006]

Did you insert manualy this prefix ( wcs_ )? :

"INSERT INTO wcs_configuration VALUES"

Have in mind that if you use Zen to patch the database, it adds the prefix automatically.

Do you have any experience with MyAdmin for MySQL ?

Another thing to do is to remove this :

ON DUPLICATE KEY UPDATE configuration_key = configuration_key

Exactly what you see above !!!

You will find this 28 times in the file

"INSTALL_PC_CONFIGURATOR_SQL PATCHES.sql.txt"

Open the above file with a text editor of your choice and use "find and replace" type command

find : ON DUPLICATE KEY UPDATE configuration_key = configuration_key

replace : JUST LEAVE IT BLANK

Then try to install

If you have any other problem, POST here or pm me or email me direct : [email protected]

[ullikah]

Hi,

I've read some the later posts in here because I'm very interested in this project because I'm working on 2 web shops.
One is for a PC retail and one is for a bycicle shop where costumers should be able to configurate their product. The engine is actually the same but on the byke shop there is are more products which exclude certain parts for configuration.
Like with PC's where you can't use an intel board with AMD CPU's.
My question: Are there exclusions possible where the script automatically excludes certain parts which are not working with an choosen part?

My second question is actually more a suggestion because I've seen that there are a view problems with server variables such as testing on localhost.

I'm not that good with php but wouldn't it make sense to define all configuration variables in an external script and include them at the beginning of all other scripts to have one place where all user/server specific variables can be found instandly?

cheers Ullika

[lebrand2006]

This was one of my first "big" projects with PHP.

It is based on Zen Cart and using functions of it. The structure could be completely diferent, but I did not know from the start how to write the code.

I started with some lines, and after there were many other ideas.

For now there is not check for compatibility, but it can be done with AJAX.

But, first of all, I thought it would be better to write the code for massive products insertion.

So, if somebody wants to build a new store, he can easily insert 100 diferent products in 5 screens.

Then I will proceed to write the code for compatibility check.

Last step is to reconstruct the code from the start, to be as you suggest so variables and defines are together ALL in the same file.

As there are many ideas for templates and compatibility with Zen Cart versions, there is a VERY LONG way to do all the above.

I believe that in the next 3-4 years it will be a nice module !

[Kegir]

I'm getting a 404 error. http://shop.pcucomputers.com/index.p...ex&cPath=28200

PC Configurator Basic works ok under admin but PC Configurator Options and the PC Configurator link are both blank.

Any idea what I did wrong. I was pretty careful copying files but when the directions said "As for the folder "pc_configurator" which contains 3 files, upload it directly to folder catalog(shop)/includes" my folder had 11 php files and 1 readme not the 3 it mentioned

[pcspot]

Hello Lebrad, I have uninstall pc configurator but my admin page > Configuration has lots of listing of "PC cponfigurator" and "PC configurator Options". How do I remove them from the menu?

thanks in advance.
pcspot.

[EMCparts]

Can it edit the Sales Message Goes Here and actually make it change?

I made the changes as shown here https://www.zen-cart.com/tutorials/i...hp?article=127 but all that accomplished was replacing the sales message with HEADER_SALES_TEXT and breaking the link to the default Zen Cart image next to it, even though I didn't change anything for that image.

[DivaVocals]

Can it edit the Sales Message Goes Here and actually make it change?

I made the changes as shown here https://www.zen-cart.com/tutorials/i...hp?article=127 but all that accomplished was replacing the sales message with HEADER_SALES_TEXT and breaking the link to the default Zen Cart image next to it, even though I didn't change anything for that image.

Ummm no.. Your question is pretty off topic for this module.. Plenty of posts on the forum cover the question you have though..

[hotenglish]

Hi im seeing if any one can help . Im building a gaming pcs site and i wanted the customers to be able to change any part of the pc to what they want . ie case , motherboard and so on . Could any one tell me when to start

Thanks

gary

[hotenglish]

Hi Can any one tell me Can you install this on a custom site you have built in dreamweaver .

Thanks

gary