数据库错误怎么办？？？

来源：百度知道编辑：UC知道时间：2024/06/17 19:56:44

我的网站常常会连接出错，过几天又好了，有没有高手帮我解决下？？？
..............

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.goods_type, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img FROM `zz37n1_db`.`ecs_goods` AS g LEFT JOIN `zz37n1_db`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('36') OR g.goods_id IN ('') ) ORDER BY shop_price ASC LIMIT 12 ) [2] => Array ( [error] => Got error 12 from table handler ) [3] => Array ( [errno] => 1030 ) )
我的网址： www.

IFNULL(mp.user_price, g.shop_price * '1') AS shop_price,

SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best,
g.is_hot, g.shop_price AS org_price,
isnull(mp.user_price, g.shop_price * '1') AS shop_price,
g.promote_price, g.goods_type, g.promote_start_date, g.promote_end_date,
g.goods_brief, g.goods_thumb , g.goods_img
FROM `zz37n1_db`.`ecs_goods` AS g
LEFT JOIN `zz37n1_db`.`ecs_member_price` AS mp
ON mp.goods_id = g.goods_id AND mp.user_rank = '0'
WHERE g.is_on_sale = 1
AND g.is_alone_sale = 1
AND g.is_delete = 0
AND (g.cat_id IN ('36') OR g.goods_id IN ('') )
ORDER BY shop_price ASC LIMIT 12 )

用VB编数据库时出现这个错误应该怎么办？ ASP连接数据库错误数据库错误：GENERALSQLERRDR 数据库的错误 asp连接数据库错误表单处理数据库错误 ASP数据库操作错误 IIS数据库调用错误更新数据库发生错误 VF数据库错误