user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT * FROM votingapi_vote v WHERE 1 = 1 AND v.content_type = 'node' AND v.content_id = 172 AND v.tag = 'upndown' AND v.uid = 0 AND v.vote_source = '18.116.60.81' AND v.timestamp >= 1747364366 in /data/avideotutorial/sites/all/modules/votingapi/votingapi.module on line 557.
user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT * FROM votingapi_vote v WHERE 1 = 1 AND v.content_type = 'node' AND v.content_id = 172 AND v.value_type = 'points' AND v.tag = 'upndown' AND v.uid = 0 AND v.vote_source = '18.116.60.81' AND v.timestamp >= 1747364366 in /data/avideotutorial/sites/all/modules/votingapi/votingapi.module on line 557.
user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: INSERT INTO votingapi_vote (content_type, content_id, value, value_type, tag, uid, timestamp, vote_source) VALUES ('node', 172, -1, 'points', 'upndown', 0, 1747367966, '18.116.60.81') in /data/avideotutorial/includes/common.inc on line 3542.
user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT v.value_type, v.tag, COUNT(v.value) as value_count, SUM(v.value) as value_sum FROM votingapi_vote v WHERE v.content_type = 'node' AND v.content_id = 172 AND v.value_type IN ('points', 'percent') GROUP BY v.value_type, v.tag in /data/avideotutorial/sites/all/modules/votingapi/votingapi.module on line 484.
user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT v.tag, v.value, v.value_type, COUNT(1) AS score FROM votingapi_vote v WHERE v.content_type = 'node' AND v.content_id = 172 AND v.value_type = 'option' GROUP BY v.value, v.tag, v.value_type in /data/avideotutorial/sites/all/modules/votingapi/votingapi.module on line 498.
user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT SUM(v.value) as value_positives, v.tag FROM votingapi_vote v WHERE v.content_type = 'node' AND v.content_id = 172 AND v.value_type = 'points' AND v.value > 0 GROUP BY v.value_type, v.tag in /data/avideotutorial/sites/all/modules/vote_up_down/vud.module on line 223.
user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT SUM(v.value) as value_negatives, v.tag FROM votingapi_vote v WHERE v.content_type = 'node' AND v.content_id = 172 AND v.value_type = 'points' AND v.value < 0 GROUP BY v.value_type, v.tag in /data/avideotutorial/sites/all/modules/vote_up_down/vud.module on line 233.
user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT * FROM votingapi_vote v WHERE 1 = 1 AND v.content_type = 'node' AND v.content_id = 178 AND v.tag = 'upndown' AND v.uid = 0 AND v.vote_source = '18.116.60.81' AND v.timestamp >= 1747364375 in /data/avideotutorial/sites/all/modules/votingapi/votingapi.module on line 557.
user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT * FROM votingapi_vote v WHERE 1 = 1 AND v.content_type = 'node' AND v.content_id = 178 AND v.tag = 'upndown' AND v.uid = 0 AND v.vote_source = '18.116.60.81' AND v.timestamp >= 1747364375 in /data/avideotutorial/sites/all/modules/votingapi/votingapi.module on line 557.

Part 2: How to Build Custom PHP and MySQL CMS Website Software

Posted Tue, 08/09/2011 - 20:07

In this part we demonstrate table creation and structure methods from inside of PHPMyAdmin. PHPMyAdmin is a great tool if you are not yet comfortable writing custom database structuring scripts using PHP. We make the website system smart enough to use just one file for all display, no matter how many pages or content the site acquires.

Source Files - http://www.developphp.com/view.php?tid=322