user plugin - need a help with existing records

[Vadim]

List #23 has element id 364 (user plugin), which should be editable by super user. One of the users (id 44) was deleted and its records should be changed to another user (id 576). But super user cannot edit and has not access to this element to edit, and just see the red note of a system: "JUser: :_load: Unable to load user with ID: 44".
Rob, can you help to change records from user 44 to user 576 in database? If I can do it by myself, please, let me know how

 

[cheesegrits]

Are you familiar with using something like phpMyAdmin?

-- hugh

 

[Vadim]

Sorry no, I'm just a user.

 

[rob]

But super user cannot edit and has not access to this element to edit,

This is because it is checked out, you should do a global check in:

site -> maintenance -> global check in

select the 'ol9i0_fabrik_elements table' option and press 'check in'.

You can then edit the element.

To avoid things being left in a checked out state always 'close' pages when you edit them. Closing (or saving) elements, forms, groups etc checks them back in, allowing them to be editable by other users.

However all that being said you won't be able to do what you want once the element is checked in, as Hugh says you will need to use PHPmyadmin to run an SQL query to update the database table's data. To do this follow these instructions:

go to your plesk server manager
click databases
select the domain whose database you want to manage
select the database you want to manage
the click on the database name and press the 'webadmin' button
this will open phpmyadmin

I opened Fabrik and checked which database table list#23 points to - in this case 'fab_nakopit_program'

In the phpmyadmin window you see the list of database tables on the left hand side, you can click on the name 'fab_nakopit_program' to view the database table.

Then click the browse tab to see the tables data

You should see the column 'program_user' this is the field whose data you need to edit.

Click on the 'SQL' tab

This opens a textarea where you can run an sql query.

Enter this query:

UPDATE `fab_nakopit_program` SET program_user = 576 WHERE program_user = 44

press the 'go' button to run the query.

The query is pretty self explainatory, it will UPDATE the table replacing the value 44 with 576 in the field program_user.

-hth
Rob

 

[Vadim]

Rob thank you for so detailed instruction for the most unknown and terrible for me area. Before its using I went to the list to check. I have no idea what's happen but I received access to this element without doing anythyng and edit it simply in a table. If you did it after your instruction - one extra thank to you!)

 

[Vadim]

just to close

 

[cheesegrits]

Sorry no, I'm just a user.

Hmmm. Well, that's part of our ongoing problem. You aren't "just a user", you are a Joomla site super administrator and web master, and (when using Fabrik) an application developer.

Building and running a successful Joomla site requires considerably more than "just a user" skillsets, regardless of whatever Joomla's marketing may tell you. You need to have a basic understanding of databases, HTML, CSS, and typically some understanding of basic PHP and JavaScript, if you need to do anything which isn't "out of box". And if you don't have this knowledge, you need a willingness to learn.

As Rob said in another post, we have spent a LOT of time walking you through basic Joomla and associated admin and housekeeping tasks, which are nothing to do with Fabrik support. And we can't carry on devoting time to teaching you this stuff. We support Fabrik, not Joomla itself.

There are many Joomla tutorials, training classes, forums and other resources on the web. It would really help you in your efforts if you spent a couple of days learning the fundamentals of J! and generic web site admin and maintenance.

You might also consider a subscription to something like the OS Training site (http://ostraning.com), where you can get excellent training courses, and support on J! admin.

-- hugh

 

[Vadim]

This is only your opinion - opinion of person who is in position of conflict of interests and cannot provide objective opinion to this question. My opinion (similar background and description) is that most part of time I work as volunteer to test Fabrik for different bugs at my site and what you do is mostly to make Fabrik working correctly or provide me information about Fabrik, which is not published within your informational resources such as tutorials etc.
If you want to transfer this discussion from sharing such opinions to more objective image, let's calculate together threads, time and their reasons at this forum. This is the only fair background, which allow you to say what did you say, otherwise this is your pressure which is far away from honest relationships.

Then I totally disagree with your attempt to avoid responsibility by such message "whatever Joomla's marketing may tell you. You need to have a basic understanding..." This is quote of Fabrik announce at official Joomla site "Fabrik gives you the power to create forms and tables that run inside Joomla without requiring knowledge of mySQL and PHP" and I didn't see any your notes there that it is not truth !! So when do you lie - in your announce at official Joomla site or in your post to me?? I trusted your announce and spent a lot of my time to integrate Fabrik to my previous site more then year ago, I payed for Silver Subscription to clear questions, which I cannot solve by myself without that special knowledge for what? to know finally that I it was not truth, and I become the victim of your fraud?? Cheesegrits, I respect you as specialist, as well as Rob, I respect your efforts to provide me support within different questions, but please, don't continue in the way where any court can define it as a fraud and will charge all damage. It is not a threat, I appeal to your common sense.

I have not special knowledge and that's why I started to use Fabrik. I'll ask for your support according using Fabrik and its bugs any time when I need your support and you have to provide it within 48 hours. This is not a question of your good will, we had a deal and this is your duty, so it is not a matter for further discussion. Of course you may also provide your detailed reasons if you think my question is out of Fabrik. I only hope that you will not abuse it, as I'm not a specialist and in most cases I simply trust you.

I see that every time when I remind about absence of respond in 48 hours you come back to the same question. Such discussion are rather frustrating for all of us and take a lot of time and not only time, so it'll be great if we will not regular come back to this topic. If you don't like my reminding, please tell me other methods, which may help me not to stop for uncertain period of time.

 

[rob]

This is only your opinion - opinion of person who is in position of conflict of interests and cannot provide objective opinion to this question.

But you were asking for something that fabrik doesn't do. This is not objective it is factual.

I provided step by step instructions well beyond anything that we are required to provide for a solution which has nothing to do with Fabrik.

Its like buying a fork and then asking the manufacturer 'how can I cut with it" - they're going to say 'get a knife'. You can continue to say 'but I want to cut with my fork' but in the end you simply can't - for certain things you need a knife. In this case you need to know some very simply sql and to use phpmyadmin.

For running any web site, including Joomla sites, you need to know or have an appreciation of certain things, understand which tool is right for which job etc, and be willing to research and learn those things you don't know.

This is quote of Fabrik announce at official Joomla site "Fabrik gives you the power to create forms and tables that run inside Joomla without requiring knowledge of mySQL and PHP" and I didn't see any your notes there that it is not truth !!

And I stick by this 100%

However, we don't say, install fabrik and you will never have to know anything else with respect to running a Joomla website, which is what I think your impression of things are.

We are just trying to make you understand the limits of what support we provide.

Cheers
Rob

 

[Vadim]

different points of view