Joomla Extensions Club 20,483 posts

[tsibidio935 Friend tsibidio935Join date: June 2012Posts: 6Downloads:0Uploads:2 Thanks: 3]

#179651

Joomla 1.5
Backend turns to this when debug enabled…

500 – •!”#$%&'( )*+,μ-.•
JDatabaseMySQL::query: 1050 – Table ‘pont_jarpx_mapid’ already exists SQL=CREATE TABLE `pont_jarpx_mapid` (`user_id` INT NOT NULL ,`rpxid` VARCHAR(50) NOT NULL);
Call stack
#
Function
Location
1
JApplication- >triggerEvent()
/home/news935/public_html/previous_backup/administrator/index.php:51
2
JDispatcher->trigger()
/home/news935/public_html/previous_backup/libraries/joomla/application/application.php:512
3
JEvent->update()
/home/news935/public_html/previous_backup/libraries/joomla/event/dispatcher.php:170
4
call_user_func_array()
/home/news935/public_html/previous_backup/libraries/joomla/event/event.php:67
5
plgSystemPlg_Jarpxnow- >onAfterInitialise()
6
JDatabaseMySQL- >query()
/home/news935/public_html/previous_backup/plugins/system/plg_jarpxnow.php:32
7
JError->raiseError()
/home/news935/public_html/previous_backup/libraries/joomla/database/database/mysql.php:231
8
JError->raise()
/home/news935/public_html/previous_backup/libraries/joomla/error/error.php:171
9
JException- >__construct()
/home/news935/public_html/previous_backup/libraries/joomla/error/error.php:136

any suggestions ?

---

Attachments:

1. 

[MoonSailor Friend MoonSailorJoin date: November 2011Posts: 1106Downloads:0Uploads:245 Thanks: 89 Thanked: 248 times in 223 posts]

#463300

Hi tsibidio935,

I need more infomation about your site – account admin and ftp for closer check. Pls give me.

Thanks

[MoonSailor Friend MoonSailorJoin date: November 2011Posts: 1106Downloads:0Uploads:245 Thanks: 89 Thanked: 248 times in 223 posts]

#463431

Hi tsibidio935,

It’s fixed. In file plg_jarpxnow.php with path “/plugins/system” :

Line 25:
[PHP]
$query = “SHOW TABLES LIKE ‘#__jarpx_mapid'”;
[/PHP]
change to
[PHP]
$_tableJARpx = $db->replacePrefix(‘#__jarpx_mapid’);
$query = “SHOW TABLES LIKE ‘$_tableJARpx'”;
[/PHP]
Line 30 :
[PHP]
$query = “CREATE TABLE `#__jarpx_mapid` (`user_id` INT NOT NULL ,`rpxid` VARCHAR(50) NOT NULL);”;
[/PHP]
change to
[PHP]
$query = “CREATE TABLE IF NOT EXISTS `#__jarpx_mapid` (`user_id` INT NOT NULL ,`rpxid` VARCHAR(50) NOT NULL);”;
[/PHP]

Thanks

1 user says Thank You to MoonSailor for this useful post

1. tsibidio935

[Author]

Posts