• [MOD] PMv2 Tutorial Republished here 5 0 5 1
Currently:  

Author Topic: [MOD] PMv2 Tutorial Republished here  (Read 771143 times)

0 Members and 1 Guest are viewing this topic.

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #405 on: August 04, 2007, 10:58:45 PM »
May be time to rewrite. ;)
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline The Sailor

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #406 on: August 04, 2007, 11:13:06 PM »
Not sure of prob ... SQL query in pm_install.php file ...

Quote
"CREATE TABLE `".PM_TABLE."` ( `pm_id` mediumint(10) unsigned NOT NULL auto_increment, `pm_type` tinyint(2) NOT NULL default '0', `pm_to` mediumint(8) NOT NULL default '0', `pm_from` mediumint(8) NOT NULL default '0', `pm_subject` varchar(255) NOT NULL default '', `pm_text` text, `pm_date` int(11) NOT NULL default '0', `pm_date_rcvd` int(11) NOT NULL default '0', `pm_ip` varchar(20) NOT NULL default '0', `pm_html` tinyint(1) NOT NULL default '0', `pm_bbcode` tinyint(1) NOT NULL default '0', `pm_smiles` tinyint(1) NOT NULL default '0', KEY `pm_id` (`pm_id`,`pm_to`,`pm_from`)) TYPE=MyISAM",
            "ALTER TABLE `".USERS_TABLE."` ADD `user_pm_inbox` int(11) NOT NULL default '0', ADD `user_pm_sentbox` int(11) NOT NULL default '0', ADD `user_pm_email` tinyint(1) NOT NULL default '1', ADD `user_pm_popup` tinyint(1) NOT NULL default '0'",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm', '1')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_inbox', '30')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_sentbox', '10')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_html', '0')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_bbcode', '1')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_img', '1')"

Note: 8) = 8 ) (no space)

can you save it from PHPMYADMIN as SQL file please, theres some errors here  :oops:
(^_^)

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #407 on: August 04, 2007, 11:23:33 PM »
Quote
".PM_TABLE."

On paragraf, change this to real table PMS name. Next, execute same paragraf in phpmyadmin (PHP execute). ;)
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline The Sailor

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #408 on: August 04, 2007, 11:30:04 PM »
Quote
".PM_TABLE."

On paragraf, change this to real table PMS name. Next, execute same paragraf in phpmyadmin (PHP execute). ;)


Really i didnt uderstand u, did you mean i have to change to PMS but is a old verion!!!
(^_^)

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #409 on: August 04, 2007, 11:32:39 PM »
Quote
Really i didnt uderstand u, did you mean i have to change to PMS but is a old verion!!!

Sorry for bad english ... I mean replace PMS_TABLE with REAL table prefix with table name in paragraf ... next - use PHPMyAdmin + select PHP query and use paragraf. :)

Examp for prefix:

Quote
4images_pms

(4images_) - one that you use (examp). If not use, change to real one you use.
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline The Sailor

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #410 on: August 04, 2007, 11:42:07 PM »
SQL-query : 

"CREATE TABLE `".4IMAGES_PM."` ( `pm_id` mediumint(10) unsigned NOT NULL auto_increment, `pm_type` tinyint(2) NOT NULL default '0', `pm_to` mediumint( NOT NULL default '0', `pm_from` mediumint( NOT NULL default '0', `pm_subject` varchar(255) NOT NULL default '', `pm_text` text, `pm_date` int(11) NOT NULL default '0', `pm_date_rcvd` int(11) NOT NULL default '0', `pm_ip` varchar(20) NOT NULL default '0', `pm_html` tinyint(1) NOT NULL default '0', `pm_bbcode` tinyint(1) NOT NULL default '0', `pm_smiles` tinyint(1) NOT NULL default '0', KEY `pm_id` (`pm_id`,`pm_to`,`pm_from`)) TYPE=MyISAM",
            "ALTER TABLE `".USERS_TABLE."` ADD `user_pm_inbox` int(11) NOT NULL default '0', ADD `user_pm_sentbox` int(11) NOT NULL default '0', ADD `user_pm_email` tinyint(1) NOT NULL default '1', ADD `user_pm_popup` tinyint(1) NOT NULL default '0'",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm', '1')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_inbox', '30')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_sentbox', '10')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_html', '0')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_bbcode', '1')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_img', '1')"

MySQL said:


You have an error in your SQL syntax near '"CREATE TABLE `".4IMAGES_PM."` ( `pm_id` mediumint(10) unsigned NOT NULL auto_in' at line 1

(^_^)

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #411 on: August 04, 2007, 11:44:27 PM »
Like this:

Quote
'4images_pm`

no ".4IMAGES_PM." ;)
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline Stoleti

  • Hero Member
  • *****
  • Posts: 574
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #412 on: August 05, 2007, 12:22:36 AM »
the install problem its solved ;)

upload and execute this install (attached here)  :mrgreen:

Offline Stoleti

  • Hero Member
  • *****
  • Posts: 574
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #413 on: August 05, 2007, 12:39:33 AM »
DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM PM_TABLE WHERE pm_to = 1 AND (pm_type = PM_SENT OR pm_type = PM_SDLT OR pm_type = PM_UNREAD OR pm_type = PM_USDLT)
Unknown column 'PM_SENT' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM PM_TABLE WHERE pm_from = 1 AND (pm_type = PM_UNREAD OR pm_type = PM_USDLT)
Unknown column 'PM_UNREAD' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM PM_TABLE WHERE pm_from = 1 AND (pm_type = PM_SENT OR pm_type = PM_RDLT)
Unknown column 'PM_SENT' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS new FROM PM_TABLE WHERE pm_to = 1 AND (pm_type = PM_UNREAD OR pm_type = PM_USDLT) ORDER BY pm_date DESC
Unknown column 'PM_UNREAD' in 'where clause'

DB Error: Bad SQL Query: SELECT pm_date FROM PM_TABLE WHERE pm_to = 1 AND (pm_type = PM_UNREAD OR pm_type = PM_USDLT) ORDER BY pm_date DESC
Unknown column 'PM_UNREAD' in 'where clause'

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

DB Error: Bad SQL Query: SELECT COUNT(p.pm_id) AS messages FROM PM_TABLE p WHERE p.pm_to = 1 AND (p.pm_type = PM_SDLT OR p.pm_type = PM_SENT OR p.pm_type = PM_USDLT OR p.pm_type = PM_UNREAD)
Unknown column 'PM_SDLT' in 'where clause'

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

Warning: Cannot modify header information - headers already sent by (output started at /home/ragnarok/public_html/includes/db_mysql.php:190) in /home/*****/public_html/pm.php on line 958

 :?

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #414 on: August 05, 2007, 05:51:19 AM »
Look that need rewrite ...
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline The Sailor

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #415 on: August 05, 2007, 07:51:13 AM »
the install problem its solved ;)

upload and execute this install (attached here)  :mrgreen:


Parse error: parse error, expecting `')'' in c:\apache\htdocs\gallery\install.php on line 10


(^_^)

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #416 on: August 05, 2007, 02:15:50 PM »
Topic too large. Think of new system: http://www.4homepages.de/forum/index.php?topic=18268.msg97389#new - lets change. :)
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline Stoleti

  • Hero Member
  • *****
  • Posts: 574
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #417 on: August 05, 2007, 04:43:25 PM »
yea damn ... still something wrong :(

somebody had the install of the old pms ??? :|

Offline The Sailor

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #418 on: August 05, 2007, 09:45:10 PM »
any idea for sql?
(^_^)

Offline Stoleti

  • Hero Member
  • *****
  • Posts: 574
    • View Profile
Re: [MOD] PMv2 Tutorial Republished here
« Reply #419 on: August 05, 2007, 10:12:35 PM »
installer isn't working, give alot of errors this last version, who had old pm(s) versions can attach here? site V@no gallery is down ?