hi

seems the table validator_access_tokens' was not created on install.

user warning: Table 'validator_access_tokens' doesn't exist query: DELETE FROM validator_access_tokens WHERE timestamp < 1272977332 in nnnn/sites/all/modules/w3c_validator/w3c_validator.module on line 136.

does anybody have the same issue?

CommentFileSizeAuthor
#3 w3c_validator.patch1.86 KBpacproduct

Comments

SaxxIng’s picture

Same problem to me too!

powery’s picture

Category: support » bug

Subscribing, the same problem.

pacproduct’s picture

Status: Active » Needs review
StatusFileSize
new1.86 KB

Actually, current version 6.x-1.x-dev already includes this fix.
To solve your problem temporarily before the new version is released, I suggest this patch that adds the missing table to the database (Based on the sources of w3c_validator version 6.x-1.x-dev of 2010-Jun-03).

powery’s picture

Dev version works. Thanks.

cpinegar’s picture

I'm getting the same error with an insert statement. I applied the dev module, and apparently during the upgrade process the create table also failed.

What to do next?

Regards,

Craig

Vote_Sizing_Steve’s picture

Here's my results of updating to dev version:

Drupal database update
warning: Invalid argument supplied for foreach() in /home/colombiaramica/www/www/includes/database.mysql-common.inc on line 69.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') /*!40100 DEFAULT CHARACTER SET UTF8 */' at line 2 query: CREATE TABLE validator_access_tokens ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/colombiaramica/www/www/includes/database.inc on line 555.
Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.

Main page
Administration pages
The following queries were executed
w3c_validator module
Update #6100
Failed: CREATE TABLE {validator_access_tokens} ) /*!40100 DEFAULT CHARACTER SET UTF8 */
stephenrobinson’s picture

mee too....

kevinwal’s picture

For now, if you just want to upgrade the current setup to include the DB table in your mysql database:

CREATE TABLE validator_access_tokens ( `id` INT unsigned NOT NULL auto_increment, `token` VARCHAR(32) DEFAULT NULL, `timestamp` INT unsigned DEFAULT NULL, `rand` INT unsigned DEFAULT NULL, `uid` INT unsigned DEFAULT NULL, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

jscm’s picture

I have the same problem. Do you suggest to install the dev release?

jscm’s picture

PLEASE!! .. Fix the problem a release a new stable release!!
I have every time notifications about this problem.

PLEASE! Fix it!

jscm’s picture

Priority: Normal » Critical
dom.’s picture

Issue summary: View changes
Status: Needs review » Closed (won't fix)

6.x version is no more supported. Not enough users and not enough life expectancy now that D8 will be released.