I am just trying to understand how you managed to update your SQL database without realizing you updated it???Fujcube wrote:Hi,
Many thanks for your help.
How I installed the MOD:
Downloaded archive and unpacked.
Opened Install.xml in browser.
Backed up appropriate files to local machine.
Copied backup files to use for editing.
Edited files as per install.xml.
Copied files to host and overwrote existing.
Copied 2 other files that were required.
Refreshed Templates & Purged Cache
I think I know where I went wrong. When I did a search for the lines to edit, I don't think I put the edits in the correct place.
No, the SQL query is to add a new entry to the phpbb_config table of the database with the name topic_preview_limit and a default value of 150. If you use Automod to install mods, it would perform this SQL query automatically. If you install mods by hand, then you need to access your SQL database (like with phpMyAdmin) and perform the SQL query... By the way, the use of the term config here does not refer to the config.php file (which you edited - gasp!).. There is a table in the database called phpbb_config.Fujcube wrote:Hi again,
Would I be correct in saying that the SQL edit was to add a default of 150 characters to the preview mod?
If so, once the mod was installed. I manually set the value to 150 which may have caused this to be thrown up:
#1062 - Duplicate entry 'topic_preview_limit' for key 1
There is no way I could have accidentally run a SQL query without knowing it!!!!
This mod is compatible with 3.0.4... compatibility with previous versions of phpBB3 usually has more to do with changes to the phpBB code rather than the database. What this mod adds to the database is compatible with phpBB 3.0.0!ranman1973 wrote:Does anyone know if this mod will work with 3.0.4?
I have successfully added other mods that were for higher versions of phpBB but they didn't require database changes, only code changes.
It installs fine in subsilver2 with Automod, so one of your other mods probably helped create the problem. You can PM me your two subsilver files (search_results and viewforum_body and I can show you the mistakes to correct).nalioth wrote:I have installed this on a 3.0.7 board, and have a similar issue as Fujicube.
The prosilver theme works fine with the mod.
The subsilver2 topic titles have become plain text (no longer clickable), and there aren't any tooltips of any sort, either.
I used Automod to install, and it installed w/o error. When I went to uninstall after finding the subsilver2 issues, Automod threw find errors.
I've selected "0" word length in the ACP, and the board works fine now (both subsilver2 and prosilver), except I've got a malfunctioning mod installed
Here is the forum.
Any help would be appreciated.
Thanks, PM on the way.VSE wrote: It installs fine in subsilver2 with Automod, so one of your other mods probably helped create the problem. You can PM me your two subsilver files (search_results and viewforum_body and I can show you the mistakes to correct).
No worries there - I don't force uninstalls with Automod.VSE wrote: As for uninstalling - never use Automod's uninstall feature! At least not until the next release. Automod does not properly uninstall mods that have in-line-find and in-line-replace edits, which this mod does have. By using Automod's uninstall option you may have actually messed things up even more
Welcome news, indeed.VSE wrote: Fortunately the new version of MODX (and soon Automod) allow us to make uninstall instructions, which I will have with the next release version of this software, so uninstalling will not be a problem any more
I tried that too (the spammers *ed that up, too)VSE wrote:Email me?nalioth wrote:I don't have enough posts to PM (thank you filthy spammers)
PM inboundDue to a spike in spam activity, we have been forced to restrict the usage of the email and private message facilities.
At this time, we require that users have a minimum of 5 posts and a registration date of more than 24 hours ago to proceed. We sincerely apologise for the inconvenience, however this is a necessary restriction. You may still PM team members.