I should edit those instructions. Rename the tables using the query I gave, use the journal installer from this hack, then use the importer.
Edit: in your case, install the journal as you would on a clean install, then run the importer again.
Thanks! After installing (and having a few problems along the way), I installed it and can currently view the entries. Just a few problems remain:
1. When installing, I saw this:
Code:
Invalid SQL: INSERT INTO phrase (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'journalmodulenotactive', 'The journal module has been deactivated.', 1000)
mysql error: Duplicate entry 'journalmodulenotactive-0-1000' for key 2
I assume it's probably because of the previous journal setup, so I dunno if you (or AN, or anyone else) could perhaps find a way to either install the missing phrases or make a phrase-uninstall script so I can try this again.
2. While it did import the entries and such, certain words like "I've" appear as "I/'ve" and whatnot, so I'm not sure if there's a way to fix this (other than editing each entry)
Thanks! After installing (and having a few problems along the way), I installed it and can currently view the entries. Just a few problems remain:
1. When installing, I saw this:
Code:
Invalid SQL: INSERT INTO phrase (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'journalmodulenotactive', 'The journal module has been deactivated.', 1000)
mysql error: Duplicate entry 'journalmodulenotactive-0-1000' for key 2
I assume it's probably because of the previous journal setup, so I dunno if you (or AN, or anyone else) could perhaps find a way to either install the missing phrases or make a phrase-uninstall script so I can try this again.
2. While it did import the entries and such, certain words like "I've" appear as "I/'ve" and whatnot, so I'm not sure if there's a way to fix this (other than editing each entry)
Thanks in advance for anyone's help
you must uninstall the phrases and then reinstall them
Ok this update will fix a possible Sql injection problem and all are encouraged to upgrade!!
To fix this flaw without overwriting find this line in journal.php:
PHP Code:
$DB_site->query("UPDATE ".TABLE_PREFIX."journals
SET lastentry='".$lastentry['entrytitle']."', entrycount=entrycount-1, lastentry_date='".$lastentry['entrydate']."',
lastentry_id='".$lastentry['entry_id']."'
WHERE journal_id='".$j."'
");
replace that with:
PHP Code:
$DB_site->query("UPDATE ".TABLE_PREFIX."journals
SET lastentry='".addslashes($lastentry['entrytitle'])."', entrycount=entrycount-1, lastentry_date='".$lastentry['entrydate']."',
lastentry_id='".$lastentry['entry_id']."'
WHERE journal_id='".$j."'
");
I will update the zip shortly. I have also attached an updated journal.php
Ok this update will fix a possible Sql injection problem and all are encouraged to upgrade!!
To fix this flaw without overwriting find this line in journal.php:
PHP Code:
$DB_site->query("UPDATE ".TABLE_PREFIX."journals
SET lastentry='".$lastentry['entrytitle']."', entrycount=entrycount-1, lastentry_date='".$lastentry['entrydate']."',
lastentry_id='".$lastentry['entry_id']."'
WHERE journal_id='".$j."'
");
replace that with:
PHP Code:
$DB_site->query("UPDATE ".TABLE_PREFIX."journals
SET lastentry='".addslashes($lastentry['entrytitle'])."', entrycount=entrycount-1, lastentry_date='".$lastentry['entrydate']."',
lastentry_id='".$lastentry['entry_id']."'
WHERE journal_id='".$j."'
");
I will update the zip shortly. I have also attached an updated journal.php
Hey!
Very nice hack. I'm going to sign up at your website just to show support in addtion to posting here.
There is a problem with the installer. It does not add the phrase "can_report_entries". Also, I had to "rebuild" all languages in able to see the phrases used in the ACP. Just to let you know if these hasn't been reported before.
Very nice hack. I'm going to sign up at your website just to show support in addtion to posting here.
There is a problem with the installer. It does not add the phrase "can_report_entries". Also, I had to "rebuild" all languages in able to see the phrases used in the ACP. Just to let you know if these hasn't been reported before.
yeah that is an issue i will hopefully resolve in version 2. also thanks for registering on my website
yeah that is an issue i will hopefully resolve in version 2. also thanks for registering on my website
NP.
However, I have one more question: I don't know why, but when I upload an avatar, the avatar on journalpage doesn't change. However, when I give the URL to the avatar, it does change. Any fixes for this?
vB Journal for vBulletin 3.0.3(v1.0.1) Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
03-11-2005, 10:59 AM
