DB Error: Bad SQL Query: Who can help me?

[hoho]

Hy guys.

I have instaled the PrivateMassage MOD but i get an Error.

--------------------------------------------------------------------------------------------------------------
DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS new FROM 4images_pm WHERE pm_to = 1 AND (pm_type = 3 OR pm_type = PM_USDLT)
Unknown column 'PM_USDLT' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(p.pm_id) AS messages FROM 4images_pm p WHERE p.pm_to = 1 AND (p.pms_type = 1 OR p.pm_type = 2 OR p.pm_type = PM_USDLT OR p.pm_type = 3)
Unknown column 'p.pms_type' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(p.pm_id) AS messages FROM 4images_pm p LEFT JOIN 4images_users u ON (u.user_id = p.pm_from) WHERE p.pm_to = 1 AND (p.pms_type = 1 OR p.pm_type = 2 OR p.pm_type = PM_USDLT OR p.pm_type = 3) AND u.user_level <> 9
Unknown column 'p.pms_type' in 'where clause'

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w008206a/includes/db_mysql.php:188) in /www/htdocs/w008206a/pm.php on line 958

-----------------------------------------------------------------------------------------------------

Please help Me .

HOHO

[KurtW]

Hi,

you need the msql table:
- p.pms_type
- PM_USDLT

Read the Mod, You must add tables in msql



cu
Kurt

[hoho]

And Haw can i make this ?

 

[CeJay]

And Haw can i make this ?

how to make tables in mySQL: http://dev.mysql.com/doc/refman/5.0/en/create-table.html

Thousands of references out there that can help you learn