Download & Extend

database prefix: missing table content_type_conference_paper

Project:Conference
Version:6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:zyxware
Status:needs review

Issue Summary

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

#1

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

#2

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

#3

Assigned to:Anonymous» zyxware
Status:needs review» active

forgot to change the status and assignment

#4

Status:active» needs review

#5

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...)

nobody click here