Recently I have started receiving the following database error. Sometimes it have other lines listed around line 2158. Most of the time its only line 2158.
Im running SMF 2.0 RC5 holding off on upgrading to 2.0 final for awhile.
Ad Seller Pro Version: 1.0.9
http://www.*****.com/forum/index.php?action=forum
Database Error: Got error 28 from storage engine
File: /home/******/public_html/forum/Sources/adseller2.php
Line: 2158
This is what is on line 2158 and before and after it.
2154: $memQuery
2155:
2156: AND " . ($showRevshare == false ? " FIND_IN_SET($LocationID, a.adlocations) AND " : "") . " l.removed = 0 AND l.disabled = 0 $revShareQuery
2157: ORDER BY RAND() LIMIT 1
==>2158: ");
2159: $adRow = $smcFunc['db_fetch_assoc']($result);
2160:
2161: if ($smcFunc['db_num_rows']($result) == 0 && $showRevshare == true)
2162: {
Hope someone might know what might be the issue.
Thanks.