Blank MOTO form - Fix

[TraceyG]

Hi Grant,

In order to get your MOTO form back you need to do the following:

- close Actinic
- browse to your site folder and locate the ActinicCatalog.mdb file (take a backup)
- open the database with MS Access
- go to 'Insert | Query'
- select 'Design View'
- go to 'View | SQL View'
- replace the contents with the following:

DELETE UserDefinedProperties.*
FROM UserDefinedProperties LEFT JOIN Variable ON 
UserDefinedProperties.nVariableID = Variable.nID
WHERE (((Variable.nID) Is Null));

- click on 'Query | Run'
- click 'OK' on the message it shows as to how many lines it is updating
- close the database

This will now stop the crash when you go to the 'Page Layouts' tab in 'Advanced Themes Configuration'.

- next go to go to 'Design|Themes|Advanced Themes Configuration|Page Layout tab | Advanced Page Configuration' and scroll to the bottom of the list. For the 'Moto Form' line, select 'MotoForm' for the 'Outer Layout' and 'MainArea' for the 'Inner Layout'.

None of your MOTO Form selectors (pink circle icon) in the Library have any layouts defined on the 'Values' tab so you need to go through each 'MOTO....' group and:

- double-click on the selector(s) in the group
- click on the 'Values' tab
- add the appropriate layout (for the 'MOTOFields' selector add all layouts and 'MOTOShortcut' add both) to the 'Layouts offered by this selector' column.

Once you have done all of this you should be able to see the MOTO Form on the 'New Order' tab.

[grantglendinnin]

Many thanks Tracey

I have just followed your steps and the MOTO form is appearing on the New Order tab. I will go ahead with a test offline order to see if the form works too.

Cheers,
Grant

[TraceyHand]

I will go ahead with a test offline order to see if the form works too.

Cheers,
Grant

nooooooooooo Grant!!
Don't do that! Why ruin a beautiful thing?

[grantglendinnin]

nooooooooooo Grant!!
Don't do that! Why ruin a beautiful thing?

Karma?
Minimum 10-character post limit sucks.

[jont]

Karma?
Minimum 10-character post limit sucks.

Are you trying to get the whole community banned for blackhat SEO?

[grantglendinnin]

Are you trying to get the whole community banned for blackhat SEO?

No, just getting 'Page 3' of this thread removed from Google by the look of it. Though I've seen much more πsh on here that could fall foul of Google's credible-content features

--Edit--

Turns out I can't use the pi sign on the forum either.

[grantglendinnin]

Tracey

I have just attempted my first upload since applying your fix yesterday and have now got 7 coding errors, which all relate to the same variable.

The 'ProductName' variable has been placed within the 'Standard MOTO Cart Product Layout' layout, but it won't work there. Click here to go to the code'

The following variables also give the same error:

UserProductDescription
CartProductTotalPrice
CartProductUnitPrice
CartProductQuantity
CartProductLineIdentifier (code shows button id="Edit")
CartProductLineIdentified (code shows button id="Delete")

In the MOTOCartProductLayout selector, I have 'Standard MOTO Cart Product Layout' in the 'Layouts offered' list, Initial Value set to Use Parent () and TLV set to Standard MOTO Cart Product Layout - which all seems correct

Any ideas?
Cheers,
Grant

[TraceyG]

Hi Grant,

That's very odd. I have checked everything against a default site and it looks right. The only thing I can see is that on a default site if I start typing 'ProductName' into the 'Standard MOTO Cart Product Layout' it brings up 'ProductName' and 'ProductNameOnline', but on your layout it only shows 'ProductLayoutOnline'. I've asked development what can cause this.

If you click 'No' to the coding error message when you upload, does the upload carry on ok?

[grantglendinnin]

If you click 'No' to the coding error message when you upload, does the upload carry on ok?

Yes, it does carry on with the upload and the online side of things seems to be working OK. I have put a standard test order through the MOTO form and everything was ok. The order was for a standard product which doesn't involve any discounts - though I'm expecting a crash as soon as I process an offline order for an item which has some form of discount.

Regards,
Grant

[grantglendinnin]

Fail.

A full site refresh yesterday has killed it. Can't do a Refresh or a standard upload anymore - these seven errors are still thrown up. I'd rather have a blank MOTO form than this - any ideas?

Cheers,
Grant

[TraceyG]

Can't do a Refresh or a standard upload anymore

What happens after you get the coding errors? Do you get any errors or does it crash with a dump file?

[grantglendinnin]

Tracey

The upload begins, sends my CSS and actinic.css and a few .pl files across every time I do an upload, despite not actually changing anything, not sure if this is common behaviour or not.

Once I get the error message, which tends to pop up just as Actinic starts working on 'Merging incremental updates at the website', I click no - and the upload finishes.

However, pages I have changed - for example, I have changed a product layout on one section which previews OK offline, but is not being uploaded.

I would appreciate it if you could inform me of a solution or how to break the MOTO form again

Cheers,
Grant


---EDIT---

Spent all afternoon so far trying my best to break the MOTO form so I can at least get a full upload - this damn thing is unbreakable!

---EDIT---

Never thought I'd ever say that

[TraceyG]

Hi Grant,

I've been trying to recreate the problem but everytime I change something and upload to my localhost the change appears, even after clicking on 'No' to the coding errors (sorry, haven't had a response to that yet). If you look at the page in the SiteHTML folder on your pc that should have been changed does it look right or wrong? Is this happening for all changes you make, ie layout changes, new products added, changes to existing products etc?

[grantglendinnin]

Hi Tracey

I opened the file in SiteHTML and the file appeared unchanged. I took a backup of the SiteHTML folder, then cleared the folder and clicked on Web>Generate Site, the file in SiteHTML is now appearing correctly, am now uploading but still got the '7 errors' message, clicking 'No' allows the upload to continue but obviously still need to resolve the 7 errors which the MOTO fix has created.

Cheers,
Grant

[TraceyG]

Hi Grant,

I've chased the development team on the 7 errors issue and hope to let you know soon. Please let me know if the changes now appear once the site is uploaded.