There can be an issue within the database that means that when you upload or conduct a site refresh, either: -
1. the Windows hourglass appears and nothing else
2. the upload dialog box disappears
3. you receive a merge error at the end of the upload
This can normally be resolved by deleting all of the records within the 'MergeFileState' and 'FileList' tables in the database.
The quickest way to do this, is to run the SQL query: -
and then the SQL query: -
directly on the database using 'Microsoft Access'.*
If however you do not have Access, there is a small program (available to download here) that will enable you to run the queries.
Please download the file, unzip it, then: -
1. Double click on the file to run it
2. Browse to the site folder** (called 'Site1' if you have no other site within the software) and select it
3. Click 'Open'
4. Paste the first SQL query in and click 'OK'
5. Click 'Yes' to apply the query
6. Click 'Ok' on the completion message to close the program
Repeat steps 1 - 5 again for the second SQL query.
PLEASE NOTE: This will cause the software to do a complete refresh of the web site.
* Microsoft Access is supplied as part of the 'Microsoft Office Professional' program suite, it is not supplied by SellerDeck.
** Depending on the installation option chosen or operating system used, the 'Site' folder can be found in either 'My Documents', 'Documents', 'Shared Documents' or 'Program Files' in the folder 'Actinic vX\Sites\' (with X replacing the version number).
1. the Windows hourglass appears and nothing else
2. the upload dialog box disappears
3. you receive a merge error at the end of the upload
This can normally be resolved by deleting all of the records within the 'MergeFileState' and 'FileList' tables in the database.
The quickest way to do this, is to run the SQL query: -
Code:
DELETE * FROM MergeFileState;
Code:
DELETE * FROM FileList;
If however you do not have Access, there is a small program (available to download here) that will enable you to run the queries.
Please download the file, unzip it, then: -
1. Double click on the file to run it
2. Browse to the site folder** (called 'Site1' if you have no other site within the software) and select it
3. Click 'Open'
4. Paste the first SQL query in and click 'OK'
5. Click 'Yes' to apply the query
6. Click 'Ok' on the completion message to close the program
Repeat steps 1 - 5 again for the second SQL query.
PLEASE NOTE: This will cause the software to do a complete refresh of the web site.
* Microsoft Access is supplied as part of the 'Microsoft Office Professional' program suite, it is not supplied by SellerDeck.
** Depending on the installation option chosen or operating system used, the 'Site' folder can be found in either 'My Documents', 'Documents', 'Shared Documents' or 'Program Files' in the folder 'Actinic vX\Sites\' (with X replacing the version number).