• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: sql error

sql error 13 years 2 months ago #12355

Hi,

I've tried several "fixes" that just don't seem to be working.

progam is installed but when I go to edit a user I get the following 500 error......

500 - An error has occurred.
JDatabaseMySQL::query: 1146 - Table 'some_site.bc_rsmembership_membership_transactions' doesn't exist SQL=SELECT t.*, m.name FROM bc_rsmembership_membership_transactions t LEFT JOIN bc_rsmembership_memberships m ON (t.membership_id = m.id) WHERE `user_id`='62' ORDER BY `date` DESC


Call stack
# Function Location
1 JAdministrator->dispatch() /home/....../administrator/index.php:67
2 JComponentHelper->renderComponent() /home/....../administrator/includes/application.php:136
3 require_once() /home/....../libraries/joomla/application/component/helper.php:162
4 JController->execute() /home/....../administrator/components/com_rsmembership/rsmembership.php:28
5 RSMembershipControllerUsers->edit() /home/....../libraries/joomla/application/component/controller.php:236
6 RSMembershipController->display() /home/....../administrator/components/com_rsmembership/controllers/users.php:30
7 JController->display() /home/....../administrator/components/com_rsmembership/controller.php:35
8 RSMembershipViewUsers->display() /home/....../libraries/joomla/application/component/controller.php:310
9 JView->get() /home/....../administrator/components/com_rsmembership/views/users/view.html.php:56
10 RSMembershipModelUsers->getUser() /home/....../libraries/joomla/application/component/view.php:364
11 JModel->_getList() /home/....../administrator/components/com_rsmembership/models/users.php:149
12 JDatabaseMySQL->loadObjectList() /home/....../libraries/joomla/application/component/model.php:284
13 JDatabaseMySQL->query() /home/....../libraries/joomla/database/database/mysql.php:458
14 JError->raiseError() /home/....../libraries/joomla/database/database/mysql.php:231
15 JError->raise() /home/....../libraries/joomla/error/error.php:171
16




Any Suggestions???
The administrator has disabled public write access.

Re:sql error 13 years 2 months ago #12363

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
Hello,

Please make sure that your server meets the product's minimum requirements:

[url]
http://www.rsjoomla.com/customer-support/documentations/76-installing-and-uninstalling/301-minimum-requirements.html
[/url]

If it does, it would be best to manually uninstall it, make sure that you have appropriate writing permissions and start over.

Manual uninstallation guide:

[url]
http://www.rsjoomla.com/customer-support/documentations/76-installing-and-uninstalling/303-manually-uninstall-rsmembership.html
[/url]
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!