I'm a newbie to drupal module and I cannot for the life of me figure out how to get rid of these warning messages. I have tried different twitter modules, unpacking in the libraries directory of the file manager, but to no avail. Here is the exact error code I'm getting when I activate the twitter module
"

* warning: array_fill() [function.array-fill]: Number of elements must be positive in /home3/cityofr2/public_html/includes/database.inc on line 252.
* warning: implode() [function.implode]: Invalid arguments passed in /home3/cityofr2/public_html/includes/database.inc on line 252.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /home3/cityofr2/public_html/modules/user/user.module on line 514.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home3/cityofr2/public_html/modules/user/user.module on line 514.

Comments

steinmb’s picture

steinmb commented
Assigned: sheeb » Unassigned
Category: task » support

Welcome noob ;) After trying all these modules you mention, did you remember to uninstall them or did you just turn them off? The twitter module does not req. any libraries to be manually installed of any kind, pls. have a look at http://drupal.org/node/430658. Make sure you have all other twitter modules turned off and properly uninstalled.

sheeb’s picture

sheeb commented

Thanks :), still trying to figure it out I'm afraid. I just uninstalled all modules other than twitter module and uninstalled all modules in libraries folder and put them in the modules folder, however still getting those exact same error messages. Any other advice??

steinmb’s picture

steinmb commented
Priority: Major » Normal

No clues what you problem is, it is not a well known problem. If this is not a live site, pls continue to turn off 3-part modules (these do you not need to uninstall) and see if you get rid of these pesky messages. These messages are you getting them then you enable the module or when you try to add a Twitter user account?

steinmb’s picture

steinmb commented

Wait a minute. If you have the 'user tweets' block turned on, try turning it off.

sheeb’s picture

sheeb commented

Great!! That seemed to do it. I turned off the user tweets block, however how do I use the module then? Sorry I'm such a newbie, and thanks for all the support

steinmb’s picture

steinmb commented
Title: Twitter module sql errors? » SQL errors in Views
Category: support » bug
Priority: Normal » Major

Right! My guess was that the $uid needed by Views where empty/borked. Still /user/[your_user_id]/twitter should still be working on those Drupal accounts you have added an twitter account to. We now need help from the maintainer (juampy) or other bright people to fix this properly.

Workaround

  1. Clone the View that ship with the Twitter module, admin/build/views/edit/tweets and save it.
  2. Edit the cloned view and remove the argument that it use and save.
  3. You now have got an global view, showing all user tweets, but hell, it is better then none :) this twitter block should work just fine.

Pls. confirm that this is working. BTW: You are using Views 2?

sheeb’s picture

sheeb commented

So, I cloned the view port and created the global view, however when I enable the module no error messages pop up, but neither does the block itself (nothing happens). I am using Views, I don't think it is Views 2. I'm starting to wonder if it's something with my install, I never entered a twitter account ID or password, wasn't sure if it was needed. But in your last post you mention "/user/[your_user_id]/twitter" I have never changed or entered any of this information, and embarrassingly enough I can not figure out how to find it, I've looked in the setup and the permissions but none of these seem to have any place to enter an account ID or such.

steinmb’s picture

steinmb commented

http://drupal.org/node/1346824

selwynpolit’s picture

selwynpolit commented

strangely, I recently added the twitter module, added my username under /user/1/edit/twitter, enabled the block 'user tweets' and I get the array_fill() warning and gripe about errors in sql syntax. Am I missing something obvious here? I apparently got my twitter username right as I see tweets at /user/1/tweets. Suggestions?

steinmb’s picture

steinmb commented

@selwynpolit did you try #6?

mdeltito’s picture

mdeltito commented

Same problem - I've used this module many times, and never had this issue. Enabled the twitter module ONLY, and I see the same errors on the views page.

Drupal 6

Liaz’s picture

Liaz commented

Same problem, drupal 6 views 2.

The argument was the proper one (1 for admin).
But indeed, I only removed the argument from the view and no more error message.

In my specific case it was no problem to remove the argument.
Thx @steinmb ;)

jphelan’s picture

jphelan commented

Same problem. Just the twitter module with one account added under UID 1 user.

jphelan’s picture

jphelan commented

Deleting the user argument from the view worked for me.

juampynr’s picture

juampynr commented
Status: Active » Closed (duplicate)

Fixed at #1367946: Unneded uid argument in Tweets block view generates PHP warnings.