Re: General error: 8

paul_nixon · ‎07-19-2018

We have never been able to work out whats going wrong, running the software also on cpanel

Payment transaction failed.

Reason

SQLSTATE[HY000]: General error: 8 attempt to write a readonly database

Has anyone an idea how to fix thank you

KuafuSoft · ‎07-19-2018

looks like you are using sqlite for magento, it could be a permission issue with magento having no writing permission on DB files.

Otherwise, turn on sql debugger and see what's the last table it attempts to update

paul_nixon · ‎07-20-2018

me<br>

me, st180yj<br>
United Kingdom<br>
T: 01785785680

</span></p>
</td>

</tr>
<tr>

<td class="method-info" style="font-family: Verdana, Arial; font-weight: normal; border-collapse: collapse; vertical-align: top; padding: 10px 15px 0; margin: 0; text-align: left; padding-bottom: 10px;">
<h6 style="font-family: Verdana, Arial; font-weight: 700; text-align: left; font-size: 12px; margin-bottom: 0px; margin-top: 5px; text-transform: uppercase;">Shipping method:</h6>
<p style="font-family: Verdana, Arial; font-weight: normal; text-align: left; font-size: 12px; margin-top: 2px; margin-bottom: 30px; line-height: 18px; padding: 0;">Shipping</p>
</td>

<td class="method-info" style="font-family: Verdana, Arial; font-weight: normal; border-collapse: collapse; vertical-align: top; padding: 10px 15px 0; margin: 0; text-align: left; padding-bottom: 10px;">
<h6 style="font-family: Verdana, Arial; font-weight: 700; text-align: left; font-size: 12px; margin-bottom: 0px; margin-top: 5px; text-transform: uppercase;">Payment method:</h6>
<p style="font-family: Verdana, Arial; font-weight: normal; text-align: left; font-size: 12px; margin-top: 2px; margin-bottom: 30px; line-height: 18px; padding: 0;">Invoice (trade customers only)</p>
<p style="font-family: Verdana, Arial; font-weight: normal; text-align: left; font-size: 12px; margin-top: 2px; margin-bottom: 30px; line-height: 18px; padding: 0;"><strong style="font-family: Verdana, Arial; font-weight: normal; text-align: left;">Purchase Order Number:</strong> <span class="nobr">2222</span></p>

</td>
</tr>
</table>
</td>
</tr>
</table>

</td>
</tr>
</table>
<h5 class="closing-text" style="font-family: Verdana, Arial; font-weight: normal; text-align: center; font-size: 22px; line-height: 32px; margin-bottom: 75px; margin-top: 30px;">Thank you, Key Diesels!</h5>
</td>
</tr>
</table>

</body>

</html>
',
5 => 'a:7:{s:7:"subject";s:34:"Key Diesels: New Order # 100000113";s:17:"return_path_email";N;s:8:"is_plain";b:0;s:10:"from_email";s:26:"sho@rivercanalrescue.co.uk";s:9:"from_name";s:5:"Sales";s:8:"reply_to";N;s:9:"return_to";N;}',
)
AFF: 1
TIME: 0.0558

## 2018-07-20 13:48:26
## 24360 ## TRANSACTION COMMIT
TIME: 0.0535

## 2018-07-20 13:48:27
## 24360 ## TRANSACTION COMMIT
TIME: 0.0831

## 2018-07-20 13:48:27
## 24360 ## TRANSACTION COMMIT
TIME: 0.0856

## 2018-07-20 13:48:32
## 22052 ## TRANSACTION COMMIT
TIME: 0.0563

## 2018-07-20 13:50:24
## 24330 ## TRANSACTION COMMIT
TIME: 0.0908

## 2018-07-20 13:50:26
## 22053 ## TRANSACTION COMMIT
TIME: 0.0660

## 2018-07-20 13:50:27
## 22053 ## TRANSACTION COMMIT
TIME: 0.0606

## 2018-07-20 13:50:29
## 22053 ## TRANSACTION COMMIT
TIME: 0.0515

## 2018-07-20 13:50:30
## 22053 ## TRANSACTION COMMIT
TIME: 0.0651

## 2018-07-20 13:50:31
## 22053 ## TRANSACTION COMMIT
TIME: 0.0768

## 2018-07-20 13:50:31
## 22053 ## QUERY
SQL: INSERT INTO `report_event` (`logged_at`, `event_type_id`, `object_id`, `subject_id`, `subtype`, `store_id`) VALUES ('2018-07-20 13:50:31', ?, ?, ?, ?, ?)
BIND: array (
0 => 1,
1 => 724,
2 => 4250497,
3 => 1,
4 => 1,
)
AFF: 1
TIME: 0.0508

## 2018-07-20 13:50:31
## 22053 ## TRANSACTION COMMIT
TIME: 0.0680

## 2018-07-20 13:50:31
## 22053 ## TRANSACTION COMMIT
TIME: 0.0672

## 2018-07-20 13:50:32
## 22053 ## TRANSACTION COMMIT
TIME: 0.0825

paul_nixon · ‎07-20-2018

so still a little lost with this one, below is the error loig

KuafuSoft · ‎07-20-2018

you have to turn log all flag on

protected $_logAllQueries       = true;

otherwise it will only log slow queries