Right, apologies if this is short and sweet, it's late and I'm off to bed!
Am running version 6.1.3 for Chariots On Hire.
Today, I ran a stock report so I could delete and purge sold stock (first one I've run..lol..I've had heaps deleted but never actually bothered to purge them before now)
Anyway, the "purge" itself came up with an error. Cannot recall it exactly but it said something about search key not being found or something.
It left the stock in the database and worked fine from there so I thought nothing of it. Was going to ask about it tomorrow.
Went to shut down today, did database backup but forgot to export a site snapshot to my removable hard drive before I did so (daily job!) so I tried to open it back up to do the snapshot.
On opening, I'm getting the following error.
There was a problem with the database
Operation: Executing the query 'DELETE * FROM [ProductProperties] WHERE ([nPropertyID] IN (1382,1383,1384,1386,1387,1388,1389,1390,1391,818,819,821,822,823,824,825,826,827,829,830,831,832,833,834,835,854,855,857,858,859,860,861,862,863,865,866,867,868,869,870,871,949,950,952,953,954,955,956,957,958,960,961,962,963,964,965,966,1178,1238,1239,1240,1241,1242,1243,1244,1245,1186,1187,1188,1189,1190,1191,1246,1247,1248,1249,1250,1251,1252,275,276,277,278,279,280,281,293,284,285,286,287,288,289,292,1883,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,704,705,707,708,709,710,711,713,714,715,716,719,545,546,548,549,550,552,554,555,556,557,560,513,514,516,517,518,519,520,522,523,524,525,528,836,837,839,840,841,842,843,844,845,847,848,849,850,851,852,853,464,465,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,1284,2015,1286,1289,1290,1291,1292,1293,1294,1295,2017,1296,1297,1298,1299,1300,1301,1302));'
Database name: C:\Program Files\Actinic Ecommerce v6\Sites\Site1\ActinicCatalo
The search key was not found in any record.
Action: Contact your Actinic reseller or Actinic Support as appropriate
Huh? I click ok "OK" and it tells me an error log has been created and do I want to view it? I click "yes" and get the attached log. (beware, it's long. All my products have lengthy components so customers can choose hire periods.)
Whether I click "yes" to view it or not, it won't open Actinic for me and I cannot get it to open now, let alone back up the snapshot.
So, any advice, please? It's desperate. I cannot process my outstanding orders!
Many thanks in advance
Tracey
Am running version 6.1.3 for Chariots On Hire.
Today, I ran a stock report so I could delete and purge sold stock (first one I've run..lol..I've had heaps deleted but never actually bothered to purge them before now)
Anyway, the "purge" itself came up with an error. Cannot recall it exactly but it said something about search key not being found or something.
It left the stock in the database and worked fine from there so I thought nothing of it. Was going to ask about it tomorrow.
Went to shut down today, did database backup but forgot to export a site snapshot to my removable hard drive before I did so (daily job!) so I tried to open it back up to do the snapshot.
On opening, I'm getting the following error.
There was a problem with the database
Operation: Executing the query 'DELETE * FROM [ProductProperties] WHERE ([nPropertyID] IN (1382,1383,1384,1386,1387,1388,1389,1390,1391,818,819,821,822,823,824,825,826,827,829,830,831,832,833,834,835,854,855,857,858,859,860,861,862,863,865,866,867,868,869,870,871,949,950,952,953,954,955,956,957,958,960,961,962,963,964,965,966,1178,1238,1239,1240,1241,1242,1243,1244,1245,1186,1187,1188,1189,1190,1191,1246,1247,1248,1249,1250,1251,1252,275,276,277,278,279,280,281,293,284,285,286,287,288,289,292,1883,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,704,705,707,708,709,710,711,713,714,715,716,719,545,546,548,549,550,552,554,555,556,557,560,513,514,516,517,518,519,520,522,523,524,525,528,836,837,839,840,841,842,843,844,845,847,848,849,850,851,852,853,464,465,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,1284,2015,1286,1289,1290,1291,1292,1293,1294,1295,2017,1296,1297,1298,1299,1300,1301,1302));'
Database name: C:\Program Files\Actinic Ecommerce v6\Sites\Site1\ActinicCatalo
The search key was not found in any record.
Action: Contact your Actinic reseller or Actinic Support as appropriate
Huh? I click ok "OK" and it tells me an error log has been created and do I want to view it? I click "yes" and get the attached log. (beware, it's long. All my products have lengthy components so customers can choose hire periods.)
Whether I click "yes" to view it or not, it won't open Actinic for me and I cannot get it to open now, let alone back up the snapshot.
So, any advice, please? It's desperate. I cannot process my outstanding orders!
Many thanks in advance
Tracey
Comment