jt-a / attract Goto Github PK

After logging in a "Table '[dbname].shots_attachments' doesn't exist" error occurs.

NOTE: error message server specific info in between [ ] changed for security purposes.

Full message:
A Database Error Occurred

Error Number: 1146

Table '[dbname].shots_attachments' doesn't exist

SELECT shots.shot_id, shots.shot_name, shots.shot_description, shots.shot_duration, statuses.status_name, shots.shot_notes, attachments.attachment_path, GROUP_CONCAT(DISTINCT shots_users.user_id SEPARATOR ", ") as user_id, GROUP_CONCAT(tasks.task_name SEPARATOR ", ") as task_names FROM (shots) LEFT JOIN shots_users ON shots_users.shot_id = shots.shot_id LEFT JOIN statuses ON statuses.status_id = shots.status_id LEFT JOIN shots_tasks ON shots_tasks.shot_id = shots.shot_id LEFT JOIN tasks ON tasks.task_id = shots_tasks.task_id LEFT JOIN scenes ON scenes.scene_id = shots.scene_id LEFT JOIN sequences ON sequences.sequence_id = scenes.sequence_id LEFT JOIN shots_attachments ON shots_attachments.shot_id = shots.shot_id LEFT JOIN attachments ON attachments.attachment_id = shots_attachments.attachment_id WHERE show_id = '1' GROUP BY shots.shot_id ORDER BY shots.shot_order asc

Filename: [local path...]/models/shots_model.php

Line Number: 33

After installation the login screen comes up. What is the default login account and password?

When installed in a subfolder below the domain, nothing gets served up after install. No login screen shows up.

Subfolder uses was domainname.com/attract

After uploading the files and setting up the database from /install folder the subsequent pages are not served up.

Setup is a web host that uses virtual servers and access is over the Internet as opposed to localhost.

Database seemed to be setup properly from the script after inspecting it from MySQL admin panel.