Our website was infected with a Trojan I have repaired the files but i now receiving the following error (see below) when browsing to the site, I guessing that one of the configure file has been overwritten, but as i haven't configure the site I only have a very basis knowledge and didn't how to proceed from here.
Could I upgrade zikula or will this destroy all the site data?
Unknown column 'pn_url' in 'field list'
SELECT pn_id AS "id",pn_name AS "name",pn_type AS "type",pn_displayname AS "displayname",pn_url AS "URL",pn_description AS "description",pn_regid AS "regid",pn_directory AS "directory",pn_version AS "version",pn_official AS "official",pn_author AS "author",pn_contact AS "contact",pn_admin_capable AS "admin_capable",pn_user_capable AS "user_capable",pn_profile_capable AS "profile_capable",pn_message_capable AS "message_capable",pn_state AS "state",pn_credits AS "credits",pn_changelog AS "changelog",pn_help AS "help",pn_license AS "license",pn_securityschema AS "securityschema" FROM _zk__modules AS tbl
kind regards
James
Watch
GitHub Core
Show your support for Zikula! Sign up at Github account and watch the Core project!
GitHub Modules
Forum Activity
- rgasch created topic »Using PageUtil::addVar() to load script code« 11:48 AM
- michiel responded to »password problem« 10:01 AM
- mazdev responded to »Hide "Register new account" and change template to 3 col« 07:50 AM
- mesteele101 created topic »Zikula 1.3.3 - Site Search 1.5.2 - Unable to turn off plug-ins« 07:48 AM
- mesteele101 responded to »ERR (3): E_USER_ERROR: Smarty error: [in pagesvar:pagesitem2en line XXX]…« 25. May
- mazdev responded to »Pages 2.5.0 and updating - Page not found« 25. May
- mesteele101 responded to »Zikula 1.3.3 - Selecting a category in Pages not working« 25. May
Zikula Blog
- Anatomy of Open Source Projects on Mar 07
- Continuous Review on Mar 01
- Not Invented Here on Feb 24
- How to Contribute Your Code at Github on Jan 13
- 10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
- Submitting Bug Report Tickets That Get Results on Aug 17
- Cozi Tricks #1: Syntax Highlighting on Aug 07
Login
Help required
-
- Rank: Registered User
- Registered: Mar 08, 2010
- Last visit: Mar 11, 2010
- Posts: 1
Posted: Mar 08, 2010 - 09:00 AM
-
**unknown user**
- Rank: Helper
- Registered: Mar 16, 2002
- Last visit: May 18, 2010
- Posts: 985
Posted: Mar 08, 2010 - 12:13 PM
Hard to say...
I would try to figure out which version was installed, my guess is a PN version 7.6.x and try to upload the original files of that PN version, after you have backed up your database [just to be sure].
Use psak to configure your config file.
If your PN version was prior to PN 0.7.6.2, upgrade to that version and see from there. Investigate your third party modules too.
- Igor -
- Rank: Helper
- Registered: Dec 31, 1969
- Last visit: May 07, 2010
- Posts: 507
Posted: Mar 08, 2010 - 04:40 PM
I think "_zk__modules" is the key. That suggests that it is a version of Zikula, not postnuke. And that's a constant I think, and it's showing the constant name rather than the constant value. Which means the value is not being set. Given that, I would start with the idea that whatever file is defining that constant is no longer PHP valid. Probably the injected trojan, or fixing the trojan, left a syntax error of some sort that needs to be fixed. The first thing I would do is "search in files" for "_zk_" and check all the resulting files for syntax errors.
- Moderated by:
- Support
