PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dcinf.flags' doesn't exist: SELECT f.name AS name, f.title AS title FROM {flags} f; Array ( ) in render_all_flags() (line 642 of /sites/all/modules/flagcoolnote/flagcoolnote.module)

Fixed by changing line: 640
$query = db_select('flags', 'f')

to: $query = db_select('flag', 'f')

I'm using the 7.x-3.x-dev branch of the Flag module

CommentFileSizeAuthor
#4 flagcoolnote-flag_table_fix-1819792.patch2.86 KByogeshchaugule8

Comments

hillmark’s picture

hillmark commented

same issue and fix on 372

yogeshchaugule8’s picture

yogeshchaugule8 commented

Hi hillmark,

I'll look at the issues and update.

Can you mention the version of flag module you are using.

Yogesh

yogeshchaugule8’s picture

yogeshchaugule8 commented
Assigned: Unassigned » yogeshchaugule8
Status: Active » Needs work

Hi hillmark, thanks for pointing this issue, this is because flag 3.x has changed the DB architecture a little bit including the table names. I'll look into it and will update here as soon as I find some way to solve this.

Thanks

Yogesh

yogeshchaugule8’s picture

yogeshchaugule8 commented
Status: Needs work » Needs review
StatusFileSize
new flagcoolnote-flag_table_fix-1819792.patch2.86 KB

Here's attached patch for fix, will push this soon to latest version.

Yogesh

yogeshchaugule8’s picture

yogeshchaugule8 commented
Status: Needs review » Fixed

I've pushed patch in latest release i.e. 7.x-1.5.

Marking as fixed.

Yogesh

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.