When using database with prefix there is an error in line 1695 conference.module

things to do:

add {} over content_type_conference_paper

so it looks like that:

$current_max_id = db_result (db_query ("SELECT (field_paper_id_value) FROM {content_type_conference_paper} ORDER BY field_paper_id_value DESC LIMIT 1"));

Comments

zyxware’s picture

zyxware commented

Hello All

I am back, I was out for about 3 weeks I will look into the issue and update shorty. Thank You for your patience.

Regards
Zyxware

zyxware’s picture

zyxware commented
Assigned: zyxware » Unassigned
Status: Active » Needs review

I have corrected the code and put it back into the CVS Repository.

It should be available in the latest DEV by tonight.

Regards
Zyxware

zyxware’s picture

zyxware commented
Assigned: Unassigned » zyxware
Status: Needs review » Active

forgot to change the status and assignment

zyxware’s picture

zyxware commented
Assigned: Unassigned » zyxware
mfh’s picture

mfh commented
Version: 6.x-1.2-beta1 » 6.x-1.x-dev

I (still) get this, or the very similar

"user warning: Table 'database.j_content_type_conference_paper' doesn't exist query: SELECT field_paper_id_value FROM j_content_type_conference_paper WHERE nid = 0 in /home/users4/xxx/www/sites/all/modules/conference/conference.module on line 1928."

Here the prefix (j_) is there...
Might the problem arise from the fact that in my current instance I did not choose "conference_paper" but another name, "manuscript", as the corresponding content type ?
Shouldn't "conference_paper" be replaced by variable("conference_ctype_paper") ?
(I know I should not be asking these questions...)