Hello,

Would someone be willing to install the database tables for Services? For some reason, they aren't being installed and I do not know how to do it. I will pay anyone willing to do so ....

Please let me know. It is pretty important that this gets done as there is an investor looking at stuff on the site Monday and I need the services module in order to run the new video player on the site (DashPlayer).

Please help. Thanks!

Comments

Surf New Media’s picture

Surf New Media commented
Title: Manually install database tables » Will Pay $50 to have someone manually install database tables

Please! Not that I am begging or anything ....

snelson’s picture

snelson commented

Try disabling the module(s), and deleting "services" from the "system" table. The re-enable services at admin/build/modules.

Also, see services.install for the create table SQL, if this still doesn't work. Should work though, are you getting any specific errors?

Scott

Surf New Media’s picture

Surf New Media commented

Thanks for writing.

The specific message I am getting is: user warning: Table 'primworg_drupal1.services_keys' doesn't exist query: SELECT * FROM services_keys in /home/primworg/public_html/includes/database.mysql.inc on line 172.

This happens whenever I try to create a key, which is needed for the DashPlayer. When I checked out the database, there were no services tables installed at all, which has brought me here.

I have not checked the system table yet, so I will try that now ... Thanks again and I will keep you posted, unless you have other ideas. Thanks.

pasqualle’s picture

pasqualle
Location 🇭🇺 Budapest
commented

you can uninstall the module on page admin/build/modules/uninstall. That should remove the record from {system} table..

Surf New Media’s picture

Surf New Media commented

OK, I tried .... I think I installed the tables correctly, but not the site won't even recognize the services module at all ... It will not show up in the module directory or anything.

I am stumped.

pasqualle’s picture

pasqualle
Location 🇭🇺 Budapest
commented

in the module directory? huh. do you mean admin/build/modules page?

start again..
1. copy the module into /sites/all/modules directory
2. enable the module on yoursite.com/admin/build/modules page
3. that's all..

Surf New Media’s picture

Surf New Media commented

It's not working .... Now when I try to create a key, I get the following error messages:

* user warning: Unknown column 'domain' in 'where clause' query: SELECT count(*) FROM services_timestamp_nonce WHERE domain = 'primetimenow.org' AND timestamp = 1220889357 AND nonce = 'JiFyiXndLC' in /home/primworg/public_html/includes/database.mysql.inc on line 172.
* user warning: Unknown column 'domain' in 'field list' query: INSERT INTO services_timestamp_nonce (domain, timestamp, nonce) VALUES ('primetimenow.org', 1220889357, 'JiFyiXndLC') in /home/primworg/public_html/includes/database.mysql.inc on line 172.
* user warning: Unknown column 'kid' in 'field list' query: SELECT kid FROM services_keys WHERE domain = 'primetimenow.org' in /home/primworg/public_html/includes/database.mysql.inc on line 172.

pasqualle’s picture

pasqualle
Location 🇭🇺 Budapest
commented

now try:
1. uninstall services on yoursite.com/admin/build/modules/uninstall
2. enable the module on yoursite.com/admin/build/modules page

you should have correct tables after reinstall..

Surf New Media’s picture

Surf New Media commented

Thank you!!!! That did it!

pasqualle’s picture

pasqualle
Location 🇭🇺 Budapest
commented
Status: Active » Fixed

oh, finally :)

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.