| Re: SQL error: query requires a full tablescan |
| by gruessle on 2006/6/18 14:10:16 Yes and it worked |
| Re: SQL error: query requires a full tablescan |
| by Dave_L on 2006/6/18 13:29:40 For anyone else who encounters this issue, skalpa posted an answer at the above link: Quote: This is just an informative message generated by MySQL and meant to tell developers that their DB structure could be more optimized, nothing really serious. |
| Re: SQL error: query requires a full tablescan |
| by Dave_L on 2006/6/17 20:54:06 I don't know, but I saw that you posted the question at http://www.peak.ne.jp/xoops/md/xhnewbb/viewtopic.php?topic_id=1509 You'll probably get help there. |
| Re: SQL error: query requires a full tablescan |
| by gruessle on 2006/6/17 18:51:12 OK Disabled the protector and removed the two protector lines from mainfile.php. Site is back up without protector now. What do I need to do to get protector working again? |
| Re: SQL error: query requires a full tablescan |
| by gruessle on 2006/6/17 18:31:24 I got in to the admin site like I said it shows me that green message that this is my first time in the admin area. Like on a new install. When I clicked cancel it let me in to the admin area and I disabled the "Xoops Protector". Now the site shows up in the user area. Still have that Warning on top le="color: #000000"><?php Warning: mysql_query(): Your query requires a full tablescan (table ty_config, 242 rows affected). Use EXPLAIN to optimize your query. in /home/vmc/public_html/x/modules/protector/class/protector.php on line 44 When I log out and back in I get that green "First time in admin area message" Some thing is very wrong |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|