June 2012 - support - lists.drupal.org

Re: [support] D6 How to have a pager use AJAX [solved]
by Jeff Greenberg 10 Jun '12

10 Jun '12

Got it. Just a drupal_add_js and a few lines of jquery.I'm working on a D6 site that is fairly extensive and for whatever reason was created without using Views. The modules all make use of pager queries and theme_pager. After looking at links for hours and still coming up empty, I hereby plead for someone to point me to a tutorial or example (or module?) for taking the standard theme_pager pager and changing it to use AJAX for paging rather than reloading the page. There are a number of ways I could approach it, but I'm sure it's been done umpteen times already, so I'd rather use someone else's wheel :-)

1 0

Re: [support] how to make this layout correctly
by George Dawson 10 Jun '12

10 Jun '12

I sympathize with your frustration. Evreything I know about php, CSS, jQuery, data modeling - it all seems to go right out the window with Drupal. So, I am frustrated too. But you seem to have found a good, patient, and knowledgeable source of help here. So, hang in there. Guy in the background. -----Original Message----- >From: Wuxi Ixuw <wuxi.ixuw(a)gmail.com> >Sent: Jun 9, 2012 5:10 PM >To: support(a)drupal.org >Subject: Re: [support] how to make this layout correctly > >My main problem is there are a lot of information that seems taking >forever to learn it. >And because this project is the project of my life especially that it is >not for profit but I found it my duty to do so. >So I am afraid to screw it with my ignorance. >This is why I am afraid. > >-- >[ Drupal support list | http://lists.drupal.org/ ]

2 1

Suggestion for Slider Module for Banner
by Hakan 09 Jun '12

09 Jun '12

I am a developing a subtheme of Zen for D7 and would like to have a slideshow covering ca. the top 1/3 of the front page where slides change at intervals I have decided and - nice but not required - the fade in/fade out effect varies between slides per my decision. I have looked at the list of slider modules on drupal.org and found a fair number but does the group have any particular recommendations/suggestions? Thanks.

3 5

FwdD6 How to have a pager use AJAX
by Jeff Greenberg 09 Jun '12

09 Jun '12

I'm working on a D6 site that is fairly extensive and for whatever reason was created without using Views. The modules all make use of pager queries and theme_pager. After looking at links for hours and still coming up empty, I hereby plead for someone to point me to a tutorial or example (or module?) for taking the standard theme_pager pager and changing it to use AJAX for paging rather than reloading the page. There are a number of ways I could approach it, but I'm sure it's been done umpteen times already, so I'd rather use someone else's wheel :-)

1 1

Exception error in Drupal 7
by Roger 09 Jun '12

09 Jun '12

I made a copy of our server site that I am developing, both database and drupal 7 file system and installed it on my home Fedora 16 box. It works ok but http://localhost/mysite/admin/structure/types/add <http://localhost/eal/admin/structure/types/add> fails with the below error: -- mysql is started and running, other things on the localhost site seem to work ok --Adding content works. --Creating new or altering taxonomies works. --Roles and permissions works. --Workbench Access works. --There are no reports in - recent log messages. --No errors on the server site. I have Cleared Caches in D7 and run drush cc 1 to clear all caches. Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {menu_links} WHERE menu_name = :menu_name AND module = :module AND link_path = :path; Array ( [:menu_name] => management [:module] => system [:path] => admin ) in toolbar_get_menu_tree() (line 286 of /var/www/html/mysite/modules/toolbar/toolbar.module). Additional PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 3 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:260:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {menu_links} WHERE menu_name = :menu_name AND module = :module AND link_path = :path; Array ( [:menu_name] =&gt; management [:module] =&gt; system [:path] =&gt; admin ) ";s:9:"%function";s:23:"toolbar_get_menu_tree()";s:5:"%file";s:48:"/var/www/html/mysite/modules/toolbar/toolbar.module";s:5:"%line";i:286;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://localhost/mysite/admin/structure/types/add [:db_insert_placeholder_7] => http://localhost/mysite/admin/structure/types/ [:db_insert_placeholder_8] => 127.0.0.1 [:db_insert_placeholder_9] => 1339213857 ) in dblog_watchdog() (line 154 of /var/www/html/mysite/modules/dblog/dblog.module) ------------------------------------------------------------------------ Uncaught exception thrown in session handler. PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 209 of /var/www/html/mysite/includes/session.inc).

1 0

Containment issue with accordion
by Gerald Klein 09 Jun '12

09 Jun '12

Hi, I am working with a glossey adaptive theme and I have a toggle (shortcode) that produces a [accordion] content section in the center area of a 3 column page, I want to include a list of images in the right column but when I do the accordion breaks containment by going past the bottom of the page instead of pushing it larger. If I take the images out of the right column it works correctly. I added clearfix in a number of containers in the center and the right column and I noticed that it is already added in a number of places by drupal. Does anyone have an idea of how to approach this to get it to function right? http://108.220.3.98/partnerships this is a URL to the offending page thanks in advance for your help. --jerry -- Gerald Klein DBA**** ContactMe(a)geraldklein.com www.geraldklein.com <http://geraldklein.com/>**** jk(a)zognet.com**** 708-599-0352**** Arch Awesome, Ranger & Vim the coding triple threat. Linux registered user #548580

1 0

Create and manage content directly from the database.
by Wipe_Out 08 Jun '12

08 Jun '12

Hi, I am creating a booking management application and the bookings are largely generated and managed from a MS Access front end working directly on a MySQL database.. Now we need to integrate these bookings into the Drupal website so that users can add or update bookings for themselves.. I have created a content type with the required fields and now need to work out how to create content directly with SQL from MS Access.. Has anyone ever created content this way or have any idea which tables need records created/updated?? Unfortunately the system needs to be able to be updated from the Drupal site and from the MS Access application so imports and feeds won't work.. Thanks for any ideas or help..

3 17

Re: [support] Create and manage content directly from the database.
by Marty Landman 07 Jun '12

07 Jun '12

Maybe I can put it a slightly different way for you. Could be you've been hacking databases so long that you are programmers, and don't know it. The fact that you thought of this and feel comfortable with the idea leads me to think so. OTOH I couldn't agree more with the other postings; to put it plainly I'd recommend working with Drupal straight out, and going from there. Doing uber-tricky stuff like working directly on the backend database is really advanced, and for a beginner the odds of it leading to pain and suffering are high. Just my two cents. Marty At 01:43 PM 6/7/2012, Metzler, David wrote: >I am not suggesting you do data synchronization, but that you >implement code that modifies the same mysql tables modified by >access, OUTSIDE of the drupal node schema. You could write a custom >module to do this. Yes you will need to learn the drupal forms api, >but that is small compared to the access code you will need to write >to get the fields in the node and revisions tables consistent. > >IF you are not programmers, what you are suggesting is not >technically feasible anyway, as you will have to do quite a bit of >programming to get the data in the node tables correct. It's not >something you can just point an access form at and expect it to work. > >I agree with Earnie, the best advice is to hire a >developer/consultant to work through this with/for you. Or to >convince your Access users to modify the data in drupal instead of the access. > >Good luck, > >Dave > >-----Original Message----- >From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] >On Behalf Of Earnie Boyd >Sent: Thursday, June 07, 2012 10:38 AM >To: support(a)drupal.org >Subject: Re: [support] Create and manage content directly from the database. > >On Thu, Jun 7, 2012 at 1:23 PM, Wipe_Out ><wipe_out(a)users.sourceforge.net> wrote: > >> > >> You don't want to update the node tables directly. You would miss out > >> on the hook implementations. You need to create a node object and use > >> node_save() to do it. You could manage this by creating a custom > >> module to push and pull the changes to an external DB for the ms > >> access entries via a hook_cron implementation. There may be a module > >> already to do this but I don't know. > >> > > > > What are the hook implementations you mention specifically?? > >I can only point you to the technical documentation. >http://api.drupal.org/api/drupal/includes%21module.inc/group/hooks/7 > > > > > If the data tables are all updated correctly will drupal not see it as a > > node? > > > >I doubt that you'll be able to update the tables correctly but not all >that is Drupal will not know that you created the node so "correctly" >is suspect to begin with. > > > As mentioned we aren't programmers so this seemed like the easier option.. > > > >Then please hire someone to do it. See consulting(a)drupal.org and >http://groups.drupal.org/jobs for posting an opportunity. > > > My concern with trying to write something to keep two sets of data > > "syncronised" is managing the whole syncronisation process and issues with > > changes happening on both sides causing a "split brain" scenario.. If both > > access interfaces are editing the same data this is reduced.. No different > > to why MySQL replication is not often attempted as master-master > because the > > sync is not easy to do reliably.. > >But the syncing scenario is the only reliable way to do it, IMO. Or, >teach the administrators to use the Drupal interface to do their >changes instead of MS Access. > >-- >Earnie >-- https://sites.google.com/site/earnieboyd >-- >[ Drupal support list | http://lists.drupal.org/ ] >-- >[ Drupal support list | http://lists.drupal.org/ ]

1 0

Re: [support] drupal_goto and views arguments
by Adm 07 Jun '12

07 Jun '12

Gerald Klein > I guess maybe I don't understand the question. exampleview/myarg should > take you to exampleview and pass myarg in? Yes: myarg is the view argument. "Metzler, David" > If clean urls are enabled, drupal_goto('exampleview/myarg') should work. > Are you 100% sure that the url is constructed properly and that there > aren't other destination= urls in play or something like that? Thanks for your replies. I'm not sure about others destination=. The result is part of ''exampleview/myarg' (final destination is ''exampleview'), not another page. That's very strange, seems like something transforms the string. ADM

3 2

[OT] off topic. possible spammer
by Anthony 07 Jun '12

07 Jun '12

2 1