Snapshot Error when Exporting

[Rich Brady]

I'm aware Snapshot Export Errors have been covered before, but I can't find any V9 Specific Threads, so I was wondering if anyone else had seen the problem in Catalog 9.02?

I've tried allsorts (even the liquorice kind) to solve the problem already:

• Compacting Databases
• Script ID Change
• Website Refresh
• Purge

It Exports the beginings on a Snapshot (what I mean is the file is on my desktop with the correct name), but not one that I can Import.
Actinic Crashes before completing the Export and the standard (Not Responding) appears at the top of the Window. This is followed by the Microsoft "Send Error Report" window.

Support have had my Site Folder for over a week and are still struggling to find out where the problem lies.

In addition: I'm running two sites, but the other (original) site Exports without any problem...

Any ideas?

[Duncan Rounding]

I have seen this on a site that had been upgraded (products exported and imported again v7 to 8 to 9) a short time ago - support had a look and managed to create a repair script for me. Contact support and let them test your snapshot.

[TraceyHand]

I had a similar problem with an V8 to 9 upgraded site too.
Turned out to be a corrupt component/permutation which I ended up having to track down and re-do the affected product (it was manifesting itself with crashes on preview too)
Is it an upgraded site? Have you noticed if anything else causes a crash?

[jont]

Similar experience here - no way to track it back so had to reinstate an old ACD as Actinic could not resolve (actually they still have it from 14 months back and have not bothered replying so guess they are unable to sort!!)

[Rich Brady]

The site was built from scratch in V9, but the original Install was V8. Interesting to hear about previous upgrade problems.

I had a similar problem with an V8 to 9 upgraded site too.
Turned out to be a corrupt component/permutation which I ended up having to track down and re-do the affected product (it was manifesting itself with crashes on preview too)
Is it an upgraded site? Have you noticed if anything else causes a crash?

I haven't noticed any crashes outside the Export, but I'll keep an eye out.

Hopefully support will get in touch with a positive outcome. The worrying thing anout it all, is that it's a really young site. I've been doing an awful lot of work on it for my clients since the last succesful Snapshot. They'll be quite a few long nights if anything goes t""ts up!

[mediamole]

I had similiar experience when I created custom variables, if you've created any just redo and try compact databases! worked for me

[Rich Brady]

I've had a look at the Variables and Layouts that I've created, but it hasn't rectified the problem.

Also, I had successfully exported since their creation, but thanks for trying to help.

[TraceyHand]

I think it's going to be a process of elimination boiling down to what you did immediately before it stopped working.
If it's going to be that difficult to pinpoint, then I would expect you'll have to rollback to your last successful one and reimplement changes since, step by step, snapshotting regularly and not carrying on when they stop working.

Have you copied/pasted and then editted any products with permutations? I've found V9 doesn't like that too much.
I think you're going to have to retrace your steps unless support can actually find the problem in the database itself (which, after over a week, seems unlikely)

[Rich Brady]

I think you're going to have to retrace your steps unless support can actually find the problem in the database itself (which, after over a week, seems unlikely)

Unfortunately, I think you're probably right! No nights out for me any time soon

[Rich Brady]

Support have still not found a solution to this, and although everything is pointing towards me reverting to an earlier sanpshot and re-doing an awaful lot, I felt I must try a few more things first.

I re-installed Actinic in a vain attempt to solve the problem, but as my other site is performing Snapshots without any problems, I was confident a re-install wasn't going to help. I was proved correct

I then thought I'd try opening the site in V8, not really knowing what to expect, I had hoped it might highlight an error, or some missing data, hell I've nothing to loose

I copied the Site 1 folder from V9 and into V8 and then opened actinic and received the following message:

There was a problem with the database

Operation: Opening the [TaxRules] table

The Microsoft Jet database engine cannot find the input table or query 'TaxRules'. Make sure it exists and that its name is spelled correctly.

Action: Contact your Actinic reseller or Actinic Support as appropriate

Further investigations in Access have confimred that there is no "TaxRules" Table within the ActinicCatalog Database.

My question now is... Does/should a V9 Site have a TaxRules Table or has it's contents been moved into othet Tax Tables in this latest Version of Actinic, or is my database missing something which is causing the problem?

Thanks in advance,

Rich

[TraceyHand]

you can't import a V9 site into V8. Mostly because there was a complete change in the way tax is handled in V9, hence your error. It won't work.

tbh, the time you've taken to 'fix' it so far, you could have reverted and re-done your changes...I still think it's the best option really.

[Rich Brady]

you can't import a V9 site into V8..

I didn't think you could, but it was a last ditch attempt in pointing me in the right direction for the scoping out the error.

I'd given myself this week, to try and rectify it before reverting back to a previous Snapshot.

Thanks for the quick repsonse Tracey

[Rich Brady]

I'm slowly re-entering info after reverting back to an old snapshot. (I finally conceded Tracey )

However, I thought it worth mentioning that it seems like Actinic did not like any of the Sections where I'd used the SPP Layout found in the AUG.

I wondered if anyone else had experienced the same problem or whether it could be something to do with the Product ID/Product Reference change I made because of an online error I'd spotted, this Thread.

Any thoughts?

P.S This is the Layout Code I'm using:

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductFormUsed%22%20%2f%3e">
<form method="post" action="<actinic:variable name="OnlineScriptURL" value="Shopping Cart Script URL" />">
<input type="hidden" name="SID" value="<Actinic:Variable Name="SectionID"/>" />
<input type="hidden" name="PAGE" value="PRODUCT" />
<input type="hidden" name="PAGEFILENAME" value="<actinic:variable name="SectionPageName" />" />
<Actinic:SECTION BLOB='<Actinic:Variable Name="SectionCatFile"/>'/>
<actinic:block if="%3cactinic%3avariable%20name%3d%22IsHostMode%22%20%2f%3e">
<!-- Hidden field when in trial mode -->
<input type="hidden" name="SHOP" value="<Actinic:Variable Name="HiddenFields"/>" />
</actinic:block>
</actinic:block>

<div class="product_list">
<div class="image_product"><a href="<actinic:block if="%3cactinic%3avariable%20name%3d%22IsLoginPageSuppressed%22%20%2f%3e%20AND%0d%3cactinic%3avariable%20name%3d%22UnregCustomersAreNotAllowed%22%20%2f%3e" ><actinic:variable name="SectionPageName" /></actinic:block><actinic:block if="%28%3cactinic%3avariable%20name%3d%22IsLoginPageSuppressed%22%20%2f%3e%20%3d%3d%20false%29%20OR%0d%28%3cactinic%3avariable%20name%3d%22UnregCustomersAreNotAllowed%22%20%2f%3e%20%3d%3d%20false%29" ><actinic:variable name="SectionURL" /></actinic:block>" target="_self"><img alt="<actinic:variable name="SectionName" encoding="strip"/>" src="<actinic:variable Name="SectionImageFileName"/>" border="0" /></a></div>
<div><h3 class="product"><a href="<actinic:block if="%3cactinic%3avariable%20name%3d%22IsLoginPageSuppressed%22%20%2f%3e%20AND%0d%3cactinic%3avariable%20name%3d%22UnregCustomersAreNotAllowed%22%20%2f%3e" ><actinic:variable name="SectionPageName" /></actinic:block><actinic:block if="%28%3cactinic%3avariable%20name%3d%22IsLoginPageSuppressed%22%20%2f%3e%20%3d%3d%20false%29%20OR%0d%28%3cactinic%3avariable%20name%3d%22UnregCustomersAreNotAllowed%22%20%2f%3e%20%3d%3d%20false%29" ><actinic:variable name="SectionURL" /></actinic:block>" target="_self"><span style="color:<actinic:variable name="Palette2" />"><actinic:variable name='SectionName'/></span></a></h3></div>
<actinic:block type="ProductList" >
<actinic:block if="%3cactinic%3avariable%20name%3d%22ProductType%22%20%2f%3e%20%21%3d%202" >
<div style="float: right;">
<actinic:block if="%3cactinic%3avariable%20name%3d%22IsAddToCartButtonShown%22%20%2f%3e%20AND%20%0d%28%3cactinic%3avariable%20name%3d%22NumberAttributesInPushButtonGrid%22%20%2f%3e%20%3d%3d%200%29" >
<actinic:variable name="AddToCartButton" />
<span class="actrequired"><Actinic:Variable Name="QuantityPrompt"/></span>
<input type="text" name="Q_<actinic:variable Name="ProductID"/>" size="4" value="<Actinic:Variable Name="DefaultQuantity"/>" class="form_input_general" />
</actinic:block>
</actinic:block>
</div>
<actinic:block type="PriceList" >
<b><actinic:variable name="PriceLayout" /></b><br><br>
</actinic:block>

</actinic:block>
<br><a href="<actinic:block if="%3cactinic%3avariable%20name%3d%22IsLoginPageSuppressed%22%20%2f%3e%20AND%0d%3cactinic%3avariable%20name%3d%22UnregCustomersAreNotAllowed%22%20%2f%3e" ><actinic:variable name="SectionPageName" /></actinic:block><actinic:block if="%28%3cactinic%3avariable%20name%3d%22IsLoginPageSuppressed%22%20%2f%3e%20%3d%3d%20false%29%20OR%0d%28%3cactinic%3avariable%20name%3d%22UnregCustomersAreNotAllowed%22%20%2f%3e%20%3d%3d%20false%29" ><actinic:variable name="SectionURL" /></actinic:block>" target="_self">More Info...</a>
</div>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductFormUsed%22%20%2f%3e">
</form>
</actinic:block>