Problems with QuickUpdates installation

[Reesy]

If anyone else has any ideas for me to try I would be very greatful.

[whocaresanyway]

Reesey,
as was explained above the problem is the configure ID
its trying to use 300 and its already in use

try this

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');

by using '' rather than an number it will auto increment

[Reesy]

Hi, thanks for your reply.
300 isnt being used by anything else as I ran the docs suggestion above first

I tied your suggestion and it worked, any suggestion as for the rest of it as I still get the same error....
ERROR: Cannot insert configuration_key "" because it already exists

Thanking you in advance.

[DrByte]

So, if you "have" the configuration group #300 (evidenced by the group appearing on the admin Configuration menu), then simply do the inserts for the "configuration" table.


Pardon the obvious question, but ... are you sure you're running this on the right database?

[Reesy]

Hi Doc,
That is what I have been trying and I get the above error.

Yes I am running this on the right database as there is only one there.

[DrByte]

but havent tried contacting the author yet as im 99% sure its an sql thing.

Who wrote the SQL ?

[Reesy]

That is the problem, im not sure, I found it on zenportali because the downloads werent available here at the time (I notice theyre back up now )

As it is a general sql issue I thought id post to see if anyone could help.

[DrByte]

Thanks for your help again doc.
I tried the above and got the same
I checked out upgrade_exceptions and it reports the same as the error above.
phpmyadmin reports that 2 items were succesfully inserted.
When I click the quick updates mod, all I get is a table with the prices only, Im pretty sure its an sql issue as none of the configs are being read from the config settings as they cant be inserted.
I will try inserting one by one now
PS yes I have searched the forum and read 4 threads related to this mod (some are 7 pages long) but havent tried contacting the author yet as im 99% sure its an sql thing.

What do you mean "got the same" ?

If you ran it by phpMyAdmin without errors, then you should have the entries in the configuration table.


Try this: go into phpMyAdmin, open the configuration table, click on Browse, sort by configuration_key, find the keys listed in the SQL statements, and either remove them, or make sure they have configuration_group_id = 300.
Of course, that would mean you need to confirm that the configuration_group table has a valid entry for #300.

[DrByte]

That is the problem, im not sure, I found it on zenportali because the downloads werent available here at the time (I notice theyre back up now )

As it is a general sql issue I thought id post to see if anyone could help.

As I recall it, portali is the one who contributed it. ....



Moving this post to the contributions area.

[Reesy]

Ok heres what I have tried in myphpadmin...

Made sure nothing is using ID-300...

SELECT configuration_group_title FROM configuration_group where configuration_group_id = 300;

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 sec)

Trying to add it one line at a time....

INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');

Inserted rows: 1
Inserted row id: 300 (Query took 0.0502 sec)

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Display the model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

Inserted rows: 1
Inserted row id: 798 (Query took 0.0091 sec)

edited a very lonnnnnnnnnnng post to say doing it this way WORKED!!!!!!
(strange because when I tried it all together it didnt like it)
HURRAH!

Thank you for your patience Chris, greatly appreciated.