user warning: Table 'drupaltest1.content_' doesn't exist query: SELECT COUNT(c.nid) FROM pe_program_credits c, content_ a WHERE a.nid = c.nid in /var/www/project/drupaltest/sites/all/modules/phpedu/pe_program/pe_program.module on line 305.

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 'AS ayear_nid, n2.title AS acad_year_title FROM node n, pe_program_credits c, t' at line 1 query: SELECT n.nid, n.title AS program_title, t.tid, t.name AS level, c.cid, c.credits_min, c.credits_max, a. AS ayear_nid, n2.title AS acad_year_title FROM node n, pe_program_credits c, term_data t, content_ a, node n2 WHERE n.nid = c.nid AND c.tid = t.tid AND a.nid = c.nid AND a. = n2.nid ORDER BY program_title ASC LIMIT 0, 100 in /var/www/project/drupaltest/sites/all/modules/phpedu/pe_program/pe_program.module on line 305.

Comments

dakala’s picture

dakala
he/him
Primary language English
Location Fairford, Glos
commented
Assigned: Unassigned » dakala

H,

It appears as if your content types were not imported correctly. Open profiles/phpedu_profile/content_types and manually import all the content types. After that, create some test data as outlined in the advanced help pages.

ashiwebi’s picture

ashiwebi commented

It remains the same there is no change.

Can you give me the readme file for the installation as phpedu has no content inside readme file.

UK_Rogue’s picture

UK_Rogue commented
Version: 6.x-1.1-beta3 » 6.x-1.1-beta5

Was this issue ever fixed? I'm working with Drupal 6.19 and phpEdu Version 6.x-1.1-beta5. I'm gradually working my way through the installation issues but this one has me stumped. profiles/phpedu_profile/content_types does not exist in this version so I cannot see the schema. I have corrected 2 major issues during install so far so I thought i'd share my journey with you.

1. Create database
2. Download all dependancies from the dependancy list plus the 2 that were not. (Taxonomy_export and cck_sync).
3. Copy modules to sites/all/modules
4. Copy phpedu_profile to Drupal profiles folder.
5. Amended the schema in sites/all/modules/phpedu/pe_program/pe_program.install and removed the default setting for field 'cid'. (pe_program_credits).
6. copied template files (calendar-month-node.tpl.php, views-view-field.tpl.php) to my theme folder.
7. Merged the template.php file with my themes template.php file.
8. Corrected duplicate declaration from template.php theme file by deleting the last function declaration. (Previously declared by phpedu module).
9. Ran Install selecting phpedu profile.
10. Manually activated modules in admin/build/modules ensuring that content_profiles was activated before the edu module.
11. Imported the taxonomy terms from profiles/phpedu_profile/taxonomy/ as they did not get setup automatically by the installation profile.

I now have 3 known issues. Plus any surprises i'm yet to encounter :-)

1. user warning: Not unique table/alias: 'content_' query AND user warning: You have an error in your SQL syntax when selecting 'Find People'.
2. Blank screen when selecting 'News'.
3. user warning: Table ******content_' doesn't exist query: SELECT. When selecting a program.

1 and 2 I can probably sort but 3 has got me stumped. I searched the web and there are signs of users who have the exact same problem with their sites without a resolution. (Just given up perhaps?). Either way I'm determined to get this working so if anyone else has a resolution then I would be grateful for the support.

additional: here's the offending line. $object = db_fetch_object(db_query("SELECT `%s` FROM {%s} WHERE nid = %d", $column, $table, $nid));

Many Thanks