● Need help with Member Application

Tue Dec 29, 2015 9:53 pm
Blabbing Noob
51 Posts
[ATF]Porthos
Currently Offline
Offline
  
Doesn't like playing games!
Reputation: 468.1
Going to be moving my site back. Did a fresh install of evo and then used a back up of the database from about 11 weeks ago so I already had most of my members(your account coRpSE is still there)  Anyway MA wasn't working so re-downloaded the new MA from here loaded, dropped old tables and when I ran the install sql I got


Error

SQL query:

--
-- Dumping data for table `nuke_MA_mapp`
--
INSERT INTO `nuke_MA_mapp`
VALUES ( 2, 0, 'User IP', '0', '0', 't', 0, 0, 0, NULL ) ;



MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1
Tue Dec 29, 2015 11:18 pm
Original Poster
Blabbing Noob
51 Posts
[ATF]Porthos
Currently Offline
Offline
  
Doesn't like playing games!
Reputation: 468.1
Never mind. Turns out my backup is corrupt so everything is getting a fresh install just to be on the safe side.


 
Wed Dec 30, 2015 12:53 pm
Clan Leader
Top Dog
Nuke Dev / Coder
3037 Posts
coRpSE
Currently Offline
Offline

Most Played:
This week: 12.7hrs.
Total Played: 2,702hrs.


  
Must be married.
Reputation: 7373.9
votes: 7
okay.


Expand
Mon Jan 04, 2016 5:43 am
Original Poster
Blabbing Noob
51 Posts
[ATF]Porthos
Currently Offline
Offline
  
Doesn't like playing games!
Reputation: 468.1
Actually am still trying to push the move back.   have messed with this and still no go. Have deleted everything re-uploaded the files and ran the fresh install sql and now I get error message at top of page and page becomes unresponsive.  

error the ma page gets is Warning: Illegal string offset 'Member Application' in public_html/modules/Member_Application/admin/index.php on line 34
Line 34 is $page_title = $lang['Member Application'];

Ideas?


 
Mon Jan 04, 2016 6:20 pm
Clan Leader
Top Dog
Nuke Dev / Coder
3037 Posts
coRpSE
Currently Offline
Offline

Most Played:
This week: 12.7hrs.
Total Played: 2,702hrs.


  
Must be married.
Reputation: 7373.9
votes: 7
Do the following edits.

Open:
public_html/modules/Member_Application/admin/index.php

Find:

Code: [ Select all ]

$page_title = $lang['Member Application'];


Replace with:

Code: [ Select all ]

$page_title = "Member Application";


 
Mon Jan 04, 2016 6:37 pm
Original Poster
Blabbing Noob
51 Posts
[ATF]Porthos
Currently Offline
Offline
  
Doesn't like playing games!
Reputation: 468.1
Well that got rid of the error on the page to make the MA but when I go to save it I get Table 'mowsite.nuke_MA_mappresp' doesn't exist. Looing in phpadmin the only table the sql installed are the nuke_MA_mapcfg and nuke_MA-mapp.


 
Mon Jan 04, 2016 7:19 pm
Clan Leader
Top Dog
Nuke Dev / Coder
3037 Posts
coRpSE
Currently Offline
Offline

Most Played:
This week: 12.7hrs.
Total Played: 2,702hrs.


  
Must be married.
Reputation: 7373.9
votes: 7
Try this SQL here:

Code: [ Select all ]

--
-- Table structure for table `nuke_MA_mappresp`
--

DROP TABLE IF EXISTS `nuke_MA_mappresp`;
CREATE TABLE IF NOT EXISTS `nuke_MA_mappresp` (
  `recno` bigint(11) NOT NULL AUTO_INCREMENT,
  `appnum` bigint(20) NOT NULL DEFAULT '0',
  `userno` bigint(20) NOT NULL DEFAULT '0',
  `qno` bigint(20) NOT NULL DEFAULT '0',
  `response` longtext,
  `adate` text,
  `formno` int(11) NOT NULL DEFAULT '0',
  `appstatus` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`recno`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


 
Mon Jan 04, 2016 7:25 pm
Original Poster
Blabbing Noob
51 Posts
[ATF]Porthos
Currently Offline
Offline
  
Doesn't like playing games!
Reputation: 468.1
Looks like that did it.  Thanks. Have to wait till our domain name goes through to use it but it is working.


 
Mon Jan 04, 2016 7:45 pm
Clan Leader
Top Dog
Nuke Dev / Coder
3037 Posts
coRpSE
Currently Offline
Offline

Most Played:
This week: 12.7hrs.
Total Played: 2,702hrs.


  
Must be married.
Reputation: 7373.9
votes: 7
glad to hear.


 
Forums ©