Add New Page bug

[RayYates]

Fatal error when adding a new page.

Steps to duplicate the error.

Click Add Page

Add a code and Desciption

Add any item (like a third party token)

Note: no items have been added at this stage.

Click Add.

Admin produces the following error.

Runtime error in /mm5/5.00/features/tui/tui_db.mvc @ [00000038:0000004c]: features/tui/tui_db.mv: Line 1477: MvQUERY: mysql_execute: Duplicate entry 'mini.mvc' for key 2

Fatal Error:

Miva Merchant has encountered a fatal error and is unable to continue. The following information may assist you in determining the cause of the error:

Error Code: MER-TUI-DTB-00055 Description: mysql_execute: Duplicate entry 'mini.mvc' for key 2 Other Information:


Sugestion: When adding a new page and the user copies a page template from a previous page it is very likely to already contain mvt items in the code.

Either dis-allow adding the template code at this step OR add the items checkboxes to this same screen.

[RayYates]

Re: Add New Page bug

Note Once this error has occured, You can't try again because the system won't let you use the same screen code again.

[Barrett]

Re: Add New Page bug

Hmm I've added some new screens without error....

What if you make a new page, then afterwards go add an item ?

[RayYates]

Re: Add New Page bug

If I add a new screen an leave the template blank, no page error occurs.

Try adding a new page; in the template area, add a token for toolkit, storehelper or some other third party token, then click Add. Please report back your results.

[Barrett]

Re: Add New Page bug

At first glance that workflow seems unnatural to me, but anyway...

clicked add page
named it
ray
raytest
pasted in a whole template of a known template with 3rd party stuff like Toolkit.
click add
success
amazingly on view of the items page the Toolkit item was already checked.

no apparent error.

[wcw]

Re: Add New Page bug

When adding a new page, any items in the template will be automatically checked in the items list of that new page.

[Barrett]

Re: Add New Page bug

When adding a new page, any items in the template will be automatically checked in the items list of that new page.

Cool then.
Looks like Ray has somthing corrupt with his installation..
We don't detect any errors with ours.

[wcw]

Re: Add New Page bug

Either that or he is trying to add a new page with the same code one was added previously and then deleted. I don't know if they fixed that bug. Or maybe didn't fix all of it. For example there is a pagexitem (or something like that) database that might not have been cleaned up when the old page was deleted.

[RayYates]

Re: Add New Page bug

Ok so I posted the order to create this problem wrong.

I have a pretty large library page templates that I re-use when developing sites. Sometimes the client has not purchased all of the modules I need yet, but I get started anyway.

Please try this

Add new page. in the template section paste

<mvt:item name="toolkitX" param="substring|l.all_settings:product:descrip,1, 20" />

Since there is no toolkitX module installed you will get this fatal error.
Error compiling template: Line 1:toolkitX is not declared in the list of valid items.

...but wait there's MORE...

Now try again to add the same page but with a blank template.

and you get this
Runtime error in /mm5/5.00/features/tui/tui_db.mvc @ [00000038:0000004c]: features/tui/tui_db.mv: Line 1477: MvQUERY: mysql_execute: Duplicate entry 'ray.mvc' for key 2

Fatal Error mysql_execute: Duplicate entry 'ray.mvc' for key 2

I looked at the MySql tables but can't figure out how to correct this.

I'm fine with the fact that the page can't be created, but now I'm locked out of using that screen code.

I can't remember the exact sequence but I also have some page templates that have been created that exibit the same error. (I think by checking and unchecking items)

The difference is that I can't edit them and I can't delete them.

[Barrett]

Re: Add New Page bug

Maybe you just need to comment out those chunks in your templates then till you need to really use them ?

[RayYates]

Re: Add New Page bug

Thanks. I know how to work around the problem. I'm just reporting what I think is a serious bug in MM5.5

This same bug can also affect 5.5 frameworks. If a framework page contains module items that have not been installed, it is possible to install a framework that contains pages than can not be edited and can not be deleted.

[Rick Wilson]

Re: Add New Page bug

Ray,

You should post this on the 5.5 bugs list too. Just to make sure Alex doesn't miss it (I'll make sure he sees this, but can't be too safe).

[wcw]

Re: Add New Page bug

I'm getting this same show stopper error. But the weird part is that it only does it with some page codes. I can't create GIFT after the same page has been deleted. But I can create TEST5 after it has been deleted. How can that be?

EDIT: I just figured out how that can be. As Ray said, try to create the page with a bogus item (one that does not exist). That gives an error and does not create a visible page. However, it is putting something in one of the databases that it DID create a page. When I was testing it was without any item in the page. So that page created correctly. Then I deleted it. Then re-added successfully.

[wcw]

Re: Add New Page bug

More info. The managedtemplates database gets a record created. However, no ???.mvc compiled template file is created due to the failure of the item. Also, there is no entry in the pages database, hence it does not show in admin so you can delete it.

Miva - Please, I need a solution to fix the corrupted store that won't cause more damage?

Then to fix this in the future, you need to have a roll back mechanism to delete the managedtemplate record if no ???.mvc is created.